> Oh dear, this excludes my usual one-item "things to think about
> when considering what database to use":
>
> * PROPER USAGE OF NULL
>
> mysql> select * from ai_test where id is null;
> +----+-------+
> | id | txt |
> +----+-------+
> | 1 | hello |
> +----+-------+
> 1 row in set (0.00 sec)
>
> ;-). I digress. Off the top of my head, in no particular order:
You're not trying hard enough:
mysql> create table test3 (a date);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test3 values (-1);
Query OK, 1 row affected (0.01 sec)
mysql> insert into test3 values ('1996-02-31');
Query OK, 1 row affected (0.00 sec)
mysql> insert into test3 values ('1996-67-31');
Query OK, 1 row affected (0.00 sec)
mysql> select * from test3;
+------------+
| a |
+------------+
| 0000-00-00 |
| 1996-02-31 |
| 0000-00-00 |
+------------+
3 rows in set (0.00 sec)
I find that even funnier...
Chris