Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Query designer does not quote column named "D" or "T" in functons properly|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||OOo 3.0 Beta|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description drewjensen.inbox 2008-06-16 06:46:50 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
Comment 1 drewjensen.inbox 2008-06-16 06:53:05 UTC
Created attachment 54501 [details] bug doc with query
Comment 2 drewjensen.inbox 2008-06-16 06:59:05 UTC
A little more testing and it appears that this only happens if the column names are d or t.
Comment 3 Frank Schönheit 2008-06-18 14:51:24 UTC
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?
Comment 4 ocke.janssen 2010-01-13 08:07:34 UTC
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.