To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55221
Issue #:|55221
Summary:|graphical query design does not cope with sub-selects
|in WHERE clauses
Component:|Database access
Version:|680m124
Platform:|All
URL:|
OS/Version:|All
Status:|NEW
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|oj
Reported by:|fs
------- Additional comments from [EMAIL PROTECTED] Thu Sep 29 03:25:19 -0700
2005 -------
- open the attached database
- open the query therein for editing
- switch off the "Run SQL command directly" button in the toolbar
- switch to graphical design view ("Switch Design View On/Off" in the toolbar)
- switch back to SQL view
=> error message "SQL syntax error"
The statement in the query is
SELECT * FROM "date_n_text" "date_n_text"
WHERE "date_n_text"."date" = (
SELECT MAX( "date" ) FROM "date_n_text" "date_n_text")
(without the linebreaks noted here)
When executing this (without "Run SQL command directly"), this succeeds, which
means our SQL parser is able to cope with this statement. "Just" the query
design seems to be unable to handle it.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
