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

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• 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
• Component/s: SQL
• Environment: All Platforms
• Assignee: Unassigned
• Reporter: Satheesh E. Bandaram
• Created: 23/Jul/05 06:06
• Updated: 30/Sep/05 02:45
• Resolved: 30/Sep/05 02:45

Description

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)