Bug #685 Column name "types" not supported in 4.1 - backwards compatibility issue
Submitted: 19 Jun 2003 13:29 Modified: 19 Jun 2003 13:43
Reporter: Chris Boyke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[19 Jun 2003 13:29] Chris Boyke 
Description:
The following table creation command works in 4.0, but not in 4.1:

create table dss_qf_img_types(
	id         	VARCHAR(254)	not null references dss_qf_img(id),
  	seq_num       	INTEGER 	not null,
  	types     	VARCHAR(254)	null,
      	primary key(id, seq_num)
);

If I change the column name "types" to something else, then it works.

How to repeat:
Using the mysql command line tool, try to run the create table command:

create table dss_qf_img_types(
	id         	VARCHAR(254)	not null references dss_qf_img(id),
  	seq_num       	INTEGER 	not null,
  	types    	VARCHAR(254)	null,
      	primary key(id, seq_num)
);

Suggested fix:
Allow "types" as a column name.
[19 Jun 2003 13:43] MySQL Verification Team 
Types is a reserved word.
http://www.mysql.com/doc/en/Reserved_words.html