List:General Discussion« Previous MessageNext Message »
From:xtango Date:July 30 2002 10:59pm
Subject:Bit XOR not working
View as plain text  
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

SELECT 1 ^ 1


>Submitter-Id:	xtango@stripped
>MySQL support: none
>Synopsis:	Bit xor not working
>Severity:	serious
>Priority:	high
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.23.51 (Source distribution)

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 2.4.19-gentoo-r7 #3 Mon Jul 22 19:25:55 ART 2002 i686
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=''
lrwxrwxrwx    1 root     root           13 Jul 30 07:16 /lib/ ->
-rwxr-xr-x    1 root     root      1425012 Jul 30 07:16 /lib/
-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/
-rwxr-xr-x    1 root     root       580404 Jul 29 21:18 /usr/lib/
lrwxrwxrwx    1 root     root           19 Jul 30 01:51 /usr/lib/libc-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

Bit XOR not workingxtango31 Jul
  • Re: Bit XOR not workingDan Nelson31 Jul
  • Re: Bit XOR not workingPaul DuBois31 Jul