>Description: The bit xor operand (^) don't seem to work on 3.23.51 on both Windows and Linux. A simple query like this (taken from the MySQL manual) will fail:
SELECT 1 ^ 1 MySQL said: You have an error in your SQL syntax near '^ 1' at line 1 >How-To-Repeat: SELECT 1 ^ 1 >Fix: ... >Submitter-Id: [EMAIL PROTECTED] >Originator: >Organization: >MySQL support: none >Synopsis: Bit xor not working >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.51 (Source distribution) >Environment: Tested on two Pentium III boxes, one running Gentoo Linux 1.2 and other running Windows 2000 Advanced Server SP2R1. The Windows box runs a standard binary installation and the Linux box runs a built from source MySQL, both version 3.23.51. System: Linux dev.jogua.com.ar 2.4.19-gentoo-r7 #3 Mon Jul 22 19:25:55 ART 2002 i686 GenuineIntel Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=i686' CXX='gcc' CXXFLAGS='-O3 -mcpu=i686 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 30 07:16 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x 1 root root 1425012 Jul 30 07:16 /lib/libc-2.2.5.so -rw-r--r-- 1 root root 2810680 Jul 30 07:16 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jul 30 07:16 /usr/lib/libc.so -rwxr-xr-x 1 root root 580404 Jul 29 21:18 /usr/lib/libc.so.5 lrwxrwxrwx 1 root root 19 Jul 30 01:51 /usr/lib/libc-client.a -> /usr/lib/c-client.a Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static --without-debug --without-bench --without-docs 'CFLAGS=-O3 -mcpu=i686' 'CXXFLAGS=-O3 -mcpu=i686 -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
