| Key: |
DERBY-468
|
| Type: |
Improvement
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
Satheesh Bandaram
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
| |
Size |
|
count.patch |
2005-09-02 08:28 AM |
Satheesh Bandaram |
5 kB |
|
|
Environment:
|
All Platforms
|
|
| Resolution Date: |
30/Sep/05 02:45 AM
|
|
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)
|
|
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) |
Show » |
| No work has yet been logged on this issue.
|
|
Unreserve COUNT keyword, if possible.
