On Wednesday 21 February 2007 1:10:41 am Tom Lane wrote:
> "Adam Rich" <adam.r@sbcglobal.net> writes:
> > I'm not apologizing for their past mistakes.. But the issue
> > you cite is no longer true:
> > "As of 5.0.2, the server requires that month and day values
> > be legal, and not merely in the range 1 to 12 and 1 to 31,
> > respectively."
>
> Really?
>
> [tgl@rh2 ~]$ mysql test
... snip ...
It gets better: The problem is not just feb 35, it's also that it doesn't warn
you that it didn't like the input format:
[head sep-head 08:49]$ mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.33 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create table test ( td DATE );
Query OK, 0 rows affected (0.11 sec)
mysql> insert into test values ('35-Feb-2007');
Query OK, 1 row affected, 1 warning (0.07 sec)
mysql> select * from test;
+------------+
| td |
+------------+
| 0000-00-00 |
+------------+
1 row in set (0.00 sec)
mysql> insert into test values ('17-Feb-2007');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> select * from test;
+------------+
| td |
+------------+
| 0000-00-00 |
| 0000-00-00 |
+------------+
2 rows in set (0.01 sec)
mysql> insert into test values ('2007-02-19');
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+------------+
| td |
+------------+
| 0000-00-00 |
| 0000-00-00 |
| 2007-02-19 |
+------------+
3 rows in set (0.00 sec)
mysql> insert into test values ('2007-02-35');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> select * from test;
+------------+
| td |
+------------+
| 0000-00-00 |
| 0000-00-00 |
| 2007-02-19 |
| 0000-00-00 |
+------------+
4 rows in set (0.00 sec)
mysql>
--
--------------------------------------------------------------
Jan de Visser jdevisser@digitalfairway.com
Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------
