Apache OpenOffice (AOO) Bugzilla – Issue 90766
Query designer does not quote column named "D" or "T" in functons properly
Last modified: 2013-08-07 15:45:41 UTC
Using DEV300 m_19, XP and Ubuntu Open any database Open / create a query. In a selection column enter a function that takes a column name Run the Query - error. The query designer is now surrending the entire string with quotes, not just the column name. see attached bug doc for example - query1
Created attachment 54501 [details] bug doc with query
A little more testing and it appears that this only happens if the column names are d or t.
fs->oj: Is there a chance to improve our parser so that it does *not* recognize D and T as keyword, when it can not appear in that place?
oj->fs: It's hard to do so. What about all the other keywords which a user could use as column name. Even when switching to sql view and disabling parsing, hsqldb doesn't accept it as valid sql. In my personal opinion we need a function auto pilot like in SRB or Calc.