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
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
bug doc with query (13.83 KB, application/vnd.sun.xml.base)
2008-06-16 06:53 UTC, drewjensen.inbox 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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.