issue comparing dates to empty string

------=_NextPart_000_000B_01C52BB6.5A6FB640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I consider this a bug, since it used to work and it now does not, and it =
seems like a valuable shorthand. At least it deserves mentioning in the =
changelog somewhere (I just looked through all of it)

In 4.0, you chould check to see if a datetime was not set with =
(Date=3D'')
Now in 4.1, that fails. I have found that the shorthand (Date=3D'0') =
works. Putting this change through all my source is an exhaustive =
process.

I think the first should also work, as it makes sense and is much easier =
than typing (Date=3D'0000-00-00 00:00:00') everywhere its needed.


------=_NextPart_000_000B_01C52BB6.5A6FB640--
Secularity [ Fr, 18 März 2005 19:31 ] [ ID #702844 ]
Datenbanken » gmane.comp.db.mysql.bugs » issue comparing dates to empty string

Vorheriges Thema: Procedure for Debugging?
Nächstes Thema: subquery fails when a NOT IN operator tests a subset with NULL values