Bug #11757 timestamp default value not allowed to be CURRENT_TIMESTAMP
Submitted: 6 Jul 2005 4:05 Modified: 6 Jul 2005 4:09
Reporter: Ian Holsman Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:5.0.6beta OS:MacOS (Mac OS/X)
Assigned to: CPU Architecture:Any

[6 Jul 2005 4:05] Ian Holsman 
Description:
CREATE TABLE `audit` (
  `id` int(11) NOT NULL auto_increment,
  `table` varchar(255) default NULL,
  `tstamp` timestamp NOT NULL default '0000-00-00 00:00:00',
  `before` text,
  `after` text,
  `cmd` varchar(20) default NULL,
  `user` varchar(20) default NULL,
  `key` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

in 5.0.6-beta-max
mysql> alter table audit alter tstamp set default 'CURRENT_TIMESTAMP';
ERROR 1067 (42000): Invalid default value for 'tstamp'
mysql> 

in 4.1.10-standard-log 
mysql> alter table audit alter tstamp set default 'CURRENT_TIMESTAMP';
Query OK, 0 rows affected, 1 warning (0.24 sec)
Records: 0  Duplicates: 0  Warnings: 0

How to repeat:
see above

Suggested fix:
make it work in 5.0.6
[6 Jul 2005 4:09] Ian Holsman 
sorry.. I just re-read the output and the warning told me it was wrong.
so closing this.