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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125162
           Summary: SQL Syntax incorrect for LEFT / RIGHT JOIN when
                    migrationg from Base to Firebird
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: silvain-dupertuis at bluewin.ch

When I migrated a database from HSQLBD to Firebird, I had many queries who
could not load. I tried different things until I discovered that the problem
came from the syntax for joins.
The syntax 
FROM { oj "..." RIGHT OUTER JOIN "...." ON "..."."..." = ...}
coming from queries build previously with HSQLBD
is not recognised and the query refuses to load
On just needs to get rid of "oj" and replaces braces with parenthesis or remove
them to get.
FROM ( "..." RIGHT OUTER JOIN "...." ON "..."."..." = ...)
or even
FROM ( "..." RIGHT OUTER JOIN "...." ON "..."."..." = ...)

Maybe the conversion tool could take care of correcting the syntax - or else
the user should get information about how to correct his queries.

-- 
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/20190507/aa5a07dc/attachment-0001.html>