Bug 57749 - UI: Misplaced ON in multiple outer join generated by query design view
Summary: UI: Misplaced ON in multiple outer join generated by query design view
Status: RESOLVED DUPLICATE of bug 42165
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Hardware: Other All
: medium normal
Assignee: Lionel Elie Mamane
Whiteboard: BSA
Keywords: patch
Depends on:
Reported: 2012-11-30 23:55 UTC by Olivier Ploton
Modified: 2012-12-02 17:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

example and patch (6.99 KB, application/zip)
2012-11-30 23:55 UTC, Olivier Ploton

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Ploton 2012-11-30 23:55:10 UTC
Created attachment 70847 [details]
example and patch

Open example file: towns.odb.
Edit query named "Continents_with_no_town_KO"
View SQL with View->Switch Design View On/Off
Generated SQL does not work and produces an error when executed. 

I think it is because there is a misplaced ON in the genarated SQL statement.
Hand-edited SQL query named "Continents_with_no_town_SQL" seems to works.

I inclued a patch. I hope it corrects the bug.

Operating System: All
Last worked in:
Comment 1 Robert Großkopf 2012-12-01 19:23:25 UTC
It_s a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=42165, but when you attached a patch I won't mark this bug as duplicate. I set it to "New".
Comment 2 Lionel Elie Mamane 2012-12-02 17:31:56 UTC

*** This bug has been marked as a duplicate of bug 42165 ***