search

kashipai / h2database

H2 Database for reference.
0 stars 0 forks source link

ROWNUM column name is ROWNUM() #526

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
H2 provides the ROWNUM function / keyword which is compatible with the 
corresponding Oracle keyword. However, H2 is incompatible in that the column 
name is ROWNUM() instead of ROWNUM. All things being equal, it would be nice if 
H2 used ROWNUM as the column name, just like Oracle does.

Another option would be to use different column names according to the original 
SQL that was used (e.g. "ROWNUM" vs "ROWNUM()", but this seems like a fair 
amount of extra complexity without any clear advantage.

Original issue reported on code.google.com by djgred...@gmail.com on 18 Nov 2013 at 6:40

Attachments: