Re: An amusing MySQL weakness--not!

[Gavin Flower <GavinFlower@xxxxxxxxxxxxxxxxx>]

On 26/06/11 16:44, Michael Nolan wrote:

Earlier today I was working on a MySQL database (not by choice, I assure you),
and I typed a statement like this:

Update tablexyz set field1 = '15' where field2 - 20;

The '-' was supposed to be an equal sign, but MySQL executed it anyway.  (Field2 is an integer.)

I was not amused.

PostgreSQL reports this as an error, of course.
--
Mike Nolan
nolan@xxxxxxxx

I am guessing that '(field2 - 20)' is evaluated, and if non-zero it is treated as true?