I'm trying to upgrade from 3.22 to 3.23.39 and have discovered that I can't
create a table which has a column named "when". This has worked in the past,
including on 3.23.36. Here is the output I got:
mysql> CREATE TABLE wasp_project_hist (
-> id int(11) DEFAULT '0' NOT NULL auto_increment,
-> project_id int(11) DEFAULT '0' NOT NULL,
-> when datetime,
-> who varchar(16) DEFAULT '' NOT NULL,
-> status varchar(16) DEFAULT '' NOT NULL,
-> comment text,
-> sent int(11),
-> hours_worked_this_week text,
-> complete enum('true','false'),
-> projected_duration int(11),
-> PRIMARY KEY (id)
-> );
ERROR 1064: You have an error in your SQL syntax near 'when datetime,
who varchar(16) DEFAULT '' NOT NULL,
status varchar(16) DEFAU' at line 4
mysql> CREATE TABLE wasp_project_hist (
-> id int(11) DEFAULT '0' NOT NULL auto_increment,
-> project_id int(11) DEFAULT '0' NOT NULL,
-> whenx datetime,
-> who varchar(16) DEFAULT '' NOT NULL,
-> status varchar(16) DEFAULT '' NOT NULL,
-> comment text,
-> sent int(11),
-> hours_worked_this_week text,
-> complete enum('true','false'),
-> projected_duration int(11),
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected (0.03 sec)
The only difference is I changed "when" to "whenx".
Is "when" now a reserved keyword, or is this a bug?
--
Chris Bare Metro Link Incorporated
[EMAIL PROTECTED] http://www.metrolink.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php