[#DERBY-468] Unreserve COUNT keyword, if possible.

Derby

Unreserve COUNT keyword, if possible.

Created: 23/Jul/05 06:06 AM Updated: 30/Sep/05 02:45 AM

Return to search

Component/s:

SQL

Affects Version/s:

10.0.2.0, 10.1.1.0, 10.2.1.6

Fix Version/s:

10.1.2.1, 10.2.1.6

Time Tracking:

Not Specified

File Attachments:

	File Name	Date Attached	Attached By	Size
	count.patch	2005-09-02 08:28 AM	Satheesh Bandaram	5 kB

Environment:

All Platforms

Resolution Date:

30/Sep/05 02:45 AM

Description

« Hide

Derby currently treats COUNT as a reserved word. This prevents having COUNT as a table name or a column name as shown below. It would be good to move COUNT from reserved word to a non-reserved word list. Having COUNT as a reserved word also causes problems while porting applications to Derby.

ij> create table count(i int);
ERROR 42X01: Syntax error: Encountered "count" at line 1, column 14.
ij> create table ts(count int);
ERROR 42X01: Syntax error: Encountered "count" at line 1, column 17.

Note that SQL standard says COUNT is a reserved word, but Derby treats several of these reserved words as non-reserved words already. (CLOB for example)

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Satheesh Bandaram made changes - 02/Sep/05 08:28 AM

Field	Original Value	New Value
Attachment		count.patch [ 12312144 ]

Satheesh Bandaram made changes - 03/Sep/05 03:25 AM

Fix Version/s		10.1.2.0 [ 12310270 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		10.2.0.0 [ 11187 ]

Satheesh Bandaram made changes - 03/Sep/05 06:29 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

Deepa Remesh made changes - 30/Sep/05 02:45 AM

Status	Closed [ 6 ]	Reopened [ 4 ]
Resolution	Fixed [ 1 ]

Deepa Remesh made changes - 30/Sep/05 02:45 AM

Fix Version/s

10.1.1.1 [ 12310332 ]

Deepa Remesh made changes - 30/Sep/05 02:45 AM

Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Fixed [ 1 ]