Unreserve COUNT keyword, if possible.

• Key: DERBY-468
• Type: Improvement
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Unassigned
• Reporter: Satheesh Bandaram
• 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

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)

Comments

[Philip Wilder]

Would removing count from the reserved words list potentially create problems with the count aggregate function?

[Satheesh Bandaram]

I am attaching a patch for this. Though I ran derbyAll yesterday, I made a slight change to the patch, so I will run the tests again and submit the fix tomorrow.

[Satheesh Bandaram]

Fix submitted to trunk. Also merged the fix to 10.1 branch.

Sending java\engine\org\apache\derby\impl\sql\compile\sqlgrammar.jj
Sending java\testing\org\apache\derbyTesting\functionTests\master\nonreserved.out
Sending java\testing\org\apache\derbyTesting\functionTests\tests\lang\nonreserved.sql
Transmitting file data ...
Committed revision 267247.

[Satheesh Bandaram]

Fix has been merged into trunk and 10.1 branches.

[Satheesh Bandaram]

Fix submitted.

reopening to fix fix version