[Libreoffice-bugs] [Bug 125162] SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125162

--- Comment #3 from Silvain Dupertuis <silvain-dupertuis at bluewin.ch> ---
Migrating to Firbird, transformation of queries with JOIN works well with the
graphic editor:
FROM { oj ... RIGHT OUTER JOIN …}
replaced by
FROM ( oj ... RIGHT OUTER JOIN ...)

But using the graphic query editor on such queries breaks the syntax
Either the additional table is ignored
Either the editer reconstruct the old syntax and breaks the query

So one has to use exclusively the SQL editor for queries with OUTER JOIN

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190522/771df163/attachment.html>