[Cologne-pm] Für Mike (aber auch alle anderen): MySQL sucks, die 9.920.930.984te

A. Pagaltzis pagaltzis at gmx.de
Fri Mar 9 05:17:19 PST 2007


Weil wir gestern drüber geredet haben:

* <http://use.perl.org/~Adrian/journal/32627>:
> My co-worker and I have just spent the last forty five minutes
> with a bug that boils down to this “interesting” behaviour…
> 
>     create temporary table the_dates (d date not null default '0000-00-00');
>     insert into the_dates values ('0000-00-00');
> 
> So far so normal.... but:
> 
>     mysql> select count(*) from the_dates where d is null;
>     +----------+
>     | count(*) |
>     +----------+
>     |        1 |
>     +----------+
>     1 row in set (0.00 sec)
> 
>     mysql> select count(*) from the_dates where d is not null;
>     +----------+
>     | count(*) |
>     +----------+
>     |        1 |
>     +----------+
>     1 row in set (0.00 sec)
> 
> … sigh…

Gruss,
-- 
Aristoteles Pagaltzis // <http://plasmasturm.org/>


More information about the Cologne-pm mailing list