[H-GEN] Mysql & bitwise xor

[Greg Black]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

On 2003-11-17, Arjen Lentz wrote:
> On Mon, 2003-11-17 at 10:29, Greg Black wrote:
> > On 2003-11-17, Clinton Roy wrote:
> > > "Paul Clarke" <paul at sitedynamics.com.au> writes:
> > > 
> > > > Is it just me or does mysql not like a bitwise xor
> > > > I am running MySQL 3.23.49
> > > 
> > > The doc at:
> > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Bit_functions
> > > indicates that bitwise xor was added in 4.0.2.
> 
> Correct.
> 
> > Another strike against mysql then -- the manual for 3.x has this
> > function documented in Section 6.3.6.1 Bit Functions without the
> > slightest indicator that it's not implemented.
> > To my way of thinking, this is inexcusable.
> 
> Well, you know I exist and have something to do with the manual, so the
> obvious way to go is to tell me about it ;-)

I thought I had managed to do that :-)

> What specific file are you referring to, in which distribution/version?

I installed the following two packages from the ports collection
for FreeBSD-4.8:

    mysql-client-3.23.55 Multithreaded SQL database (client)
    mysql-server-3.23.55 Multithreaded SQL database (server)

They come with documentation, which is installed by the port
into /usr/local/share/doc/mysql/manual.html which is where I
quoted from.  In that version of the manual, which accompanies
that MySQL release, the XOR and ^ things are documented, but
without any indication that they are not provided by the MySQL
release that the documentation refers to.

I hope that's clear.  If not, let me know and I'll try to give
you any extra information that you might need.

> I'd very much like to see the exact location, so that we can establish
> whether the problem indeed exists

The problem certainly exists.  The offending section of the
manual (as described above) is Section 6.3.6.1 Bit Functions (as
mentioned in my previous message and quoted above).

Cheers, Greg

--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/