List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:June 15 2007 2:29pm
Subject:Change in behaviour in version 5.0.41
View as plain text  
Dear MySql,

I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with 
date comparisons.

In 5.0.26:        '2007-06-15' = '2007-06-15 00:00:00' is True.
In 5.0.41:        '2007-06-15' = '2007-06-15 00:00:00' is False.
In 5.1.6-alpha:   '2007-06-15' = '2007-06-15 00:00:00' is True.

This has caused us a few problems.  Is this the way things should be, 
because this change does not seem right?

I am also very worried that this behaviour revert when we role out 5.1?

Does any member know whether this is a bug, or just an anoying feature?

Regards,

Ben


To Replicate:

CREATE TABLE t (d DATE);
INSERT INTO t VALUES ('2007-06-15');
SELECT COUNT(*) FROM t WHERE d = '2007-06-15 00:00:00';
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
SELECT COUNT(*) FROM t WHERE d = '2007-06-15';
+----------+
| COUNT(*) |
+----------+
|        1 |
+----------+



Thread
Change in behaviour in version 5.0.41Ben Clewett15 Jun
  • Re: Change in behaviour in version 5.0.41Baron Schwartz15 Jun
  • Re: Change in behaviour in version 5.0.41Mogens Melander15 Jun
  • Re: Change in behaviour in version 5.0.41Paul DuBois18 Jun
    • Re: Change in behaviour in version 5.0.41Baron Schwartz18 Jun
      • Re: Change in behaviour in version 5.0.41Paul DuBois19 Jun