An amusing MySQL weakness--not!

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: An amusing MySQL weakness--not!
Date: 2011-06-26 04:44:49
Message-ID: BANLkTikAj1YO7Vzz5wYpLt5PvodbSwF6nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tssi(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2011-06-26 04:53:02 Re: unique across two tables
Previous Message Nigel Heron 2011-06-26 03:58:40 Re: blks_read/blks_hit stats