>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: xtango@stripped
>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
