I have a module that I'm trying to utilize, but throws an error since the module is using the reserved word "date." The module is the Rules module.
Here is the SQL that it is trying to execute:

SELECT * FROM (SELECT TAB.*, ROWNUM RWN_TO_REMOVE FROM (SELECT r.* FROM rules_scheduler r WHERE (date <= 1317726573) ) TAB) WHERE RWN_TO_REMOVE BETWEEN 1 AND 1000

When I change date to "DATE" it works.

Is is possible to add the ability to convert reserved words to the quoted uppercase so that all SQL statements work (even if a reserved word is used)?

Thanks!

Comments

aaaristo’s picture

aaaristo commented
Status: Needs work » Postponed

This will not be fixed until i implement some kind of sql parser, like the one from duellj. There are reserved words that are automatically translated but DATE cannot be one of those actually because it is used in DDLs. So you have to change the module code actually.

aaaristo’s picture

aaaristo commented

well probably we can do it checking if we are parsing a DDL or not... going to fix it

aaaristo’s picture

aaaristo commented
Status: Postponed » Needs work
aaaristo’s picture

aaaristo commented

fixed in 1.10

aaaristo’s picture

aaaristo commented
Status: Needs work » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.