Hans, the problem is partially fixed in 4.1.1. You get a warning from inserting a nonsensical date. But it still accepts '1996-02-31' without a warning, though there are max 29 days in February. I have now notified the developers about this bug.
Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a non-free hot backup tool for MySQL ..... [EMAIL PROTECTED]:~/mysql-4.1/client> mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.1-alpha-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database data_test ; Query OK, 1 row affected (0.01 sec) mysql> use data_test; Database changed mysql> create table test3 (a date); Query OK, 0 rows affected (0.18 sec) mysql> insert into test3 values (-1); Query OK, 1 row affected, 1 warning (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, 1 warning (0.00 sec) mysql> select * from test3; +------------+ | a | +------------+ | 0000-00-00 | | 1996-02-31 | | 0000-00-00 | +------------+ 3 rows in set (0.03 sec) mysql> ----- Original Message ----- From: ""Hans van Harten"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, August 22, 2003 12:27 AM Subject: MySQL running out of date > ------=_NextPart_000_0242_01C36839.43CE8B60 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Some make the laughing stock of MySQL with this code: > create database data_test ; > use data_test; > create table test3 (a date); > insert into test3 values (-1); > insert into test3 values ('1996-02-31'); > insert into test3 values ('1996-67-31'); > select * from test3; > > I ran it on MYSQL-4.10-max and was not amused. > Anyone to comment?? > > HansH > ------=_NextPart_000_0242_01C36839.43CE8B60-- > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
