Issue 108593

Summary: Base puts double quotes around (Oracle's) keyword SYSDATE in query throws "invalid identifier" error.
Product: Base Reporter: smithtv <toddvsmith>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: bz-ooo, issues
Version: OOO310m19   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description smithtv 2010-01-23 01:03:08 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: 

Comment 1 Frank Schönheit 2010-02-01 20:34:25 UTC
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.