To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108079
Issue #|108079
Summary|query designer generates invalid SQL when multiple non
|-standard joins are used
Component|Database access
Version|OOo 3.1.1
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 f...@openoffice.org Tue Jan 5 09:33:17 +0000
2010 -------
- open the attached database document
- open the contained query in the graphical query designer ("Edit" from its
context menu)
- change the type of both joins from "Inner" to "Left"
- execute the query by pressing F4
=> you get an error saying something like "Unexpected token ..."
If you examine the SQL statement, you find it to be something like the following
(shortened):
SELECT ...
FROM "more events"
LEFT OUTER JOIN "events"
LEFT OUTER JOIN "time stamps"
ON "events"."when" = "time stamps"."when"
ON "more events"."when" = "time stamps"."when"
, which of course is invalid SQL, the proper version would be something like
SELECT ...
FROM "time stamps"
LEFT OUTER JOIN "events"
ON "events"."when" = "time stamps"."when"
LEFT OUTER JOIN "more events"
ON "more events"."when" = "time stamps"."when"
---------------------------------------------------------------------
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
