jpipes@serialcoder:~/repos/drizzle/trunk-with-temporal/tests$ ../client/drizzle --user=root --port=9306
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 1
Server version: 7.0.0 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
drizzle> use test
Database changed
drizzle> create table t1 (d1 date not null);
Query OK, 0 rows affected (0.02 sec)
drizzle> INSERT INTO t1 VALUES('2004-0-31');
ERROR 1686 (HY000): Received an invalid datetime value '2004-0-31'.
Fixed:
jpipes@ serialcoder: ~/repos/ drizzle/ trunk-with- temporal/ tests$ ../client/drizzle --user=root --port=9306
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 1
Server version: 7.0.0 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
drizzle> use test
Database changed
drizzle> create table t1 (d1 date not null);
Query OK, 0 rows affected (0.02 sec)
drizzle> INSERT INTO t1 VALUES( '2004-0- 31');
ERROR 1686 (HY000): Received an invalid datetime value '2004-0-31'.