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)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Lionel Elie Mamane
URL:
Whiteboard: BSA
Keywords: patch
Depends on:
Blocks:
 
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:

Attachments
example and patch (6.99 KB, application/zip)
2012-11-30 23:55 UTC, Olivier Ploton 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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: 4.0.0.0.alpha1
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 ***