Apache OpenOffice (AOO) Bugzilla – Issue 108593
Base puts double quotes around (Oracle's) keyword SYSDATE in query throws "invalid identifier" error.
Last modified: 2013-08-07 15:45:09 UTC
When running a query against an Oracle 9i database the product adds double quotes around key word SYSDATE causing Oracle to throw an ‘ORA- 00904: “SYSDATE”:invalid identifier’ error. Example: SELECT * FROM "A_TABLE" WHERE "THE_DATE" > SYSDATE is changed to: SELECT * FROM "A_TABLE" WHERE "THE_DATE" > "SYSDATE" :(
fs->oj: Would be great if we could enhance our parser to accept a runtime-defined list of additional tokens. That is, instead of hard-coding the SYSDATE identifier in the parser, we should have a per-datasource(-type) list of additional identifiers, which are accepted by the parser.