https://bugs.freedesktop.org/show_bug.cgi?id=57749
Priority: medium
Bug ID: 57749
Keywords: regression
Assignee: [email protected]
Summary: UI: Misplaced ON in multiple outer join generated by
query design view
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: unspecified
Component: Database
Product: LibreOffice
Created attachment 70847
--> https://bugs.freedesktop.org/attachment.cgi?id=70847&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
