Issue 90766

Summary: Query designer does not quote column named "D" or "T" in functons properly
Product: Base Reporter: drewjensen.inbox
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.0 Beta   
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
bug doc with query none

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.