An amusing MySQL weakness--not! - Mailing list pgsql-general

From Michael Nolan
Subject An amusing MySQL weakness--not!
Date
Msg-id BANLkTikAj1YO7Vzz5wYpLt5PvodbSwF6nw@mail.gmail.com
Whole thread Raw
Responses Re: An amusing MySQL weakness--not!  (merlyn@stonehenge.com (Randal L. Schwartz))
Re: An amusing MySQL weakness--not!  (Darren Duncan <darren@darrenduncan.net>)
Re: An amusing MySQL weakness--not!  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
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@tssi.com

pgsql-general by date:

Previous
From: Nigel Heron
Date:
Subject: Re: blks_read/blks_hit stats
Next
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: An amusing MySQL weakness--not!