Problem with timestamp default values

Hi,

There seems to be a problem with setting default values for the timestamp
column type in version 4.0.17:

mysql> create table test (t timestamp default '2001-01-01 00:00:00' not null);
ERROR 1067: Invalid default value for 't'


In 4.0.16 this works normally:

mysql> create table test (t timestamp default '2001-01-01 00:00:00' not null);
Query OK, 0 rows affected (0.00 sec)


This also occurs when using other formats (YYYYMMDDHHMMSS and smaller), so
the timestamp column is practically broken when it comes to default
values.


Regards,

--
Predrag Malicevic
BLIC.NET ISP
+387-51-240-830
http://www.blic.net/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org