[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