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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.