[ http://issues.apache.org/jira/browse/DERBY-468?page=all ] Deepa Remesh reopened DERBY-468: --------------------------------
reopening to fix fix version > Unreserve COUNT keyword, if possible. > ------------------------------------- > > Key: DERBY-468 > URL: http://issues.apache.org/jira/browse/DERBY-468 > Project: Derby > Type: Improvement > Components: SQL > Versions: 10.0.2.0, 10.1.1.0, 10.2.0.0 > Environment: All Platforms > Reporter: Satheesh Bandaram > Priority: Minor > Fix For: 10.1.2.0, 10.2.0.0, 10.1.1.1 > Attachments: count.patch > > 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) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
