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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
