Issue 108593

Summary:	Base puts double quotes around (Oracle's) keyword SYSDATE in query throws "invalid identifier" error.
Product:	Base	Reporter:	smithtv <toddvsmith>
Component:	code	Assignee:	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: 
SELECT * FROM "A_TABLE" WHERE "THE_DATE" > "SYSDATE"

:(

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.