Issue 90766 - Query designer does not quote column named "D" or "T" in functons properly
Summary: Query designer does not quote column named "D" or "T" in functons properly
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.0 Beta
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-06-16 06:46 UTC by drewjensen.inbox
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

bug doc with query (13.83 KB, application/vnd.sun.xml.base)
2008-06-16 06:53 UTC, drewjensen.inbox
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.