[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 #9 from Alex Thurgood <iplaw67 at tuta.io> ---
@Silvain :

the "{oj" construct is a leftover from ODBC compliant processing.

There used to be a property under Advanced Properties of the database
connection which could be toggled on/off. This Advanced Properties dialog
appears to have been moved to the Advanced Configuration tool.

I would suggest 2 things :

- check in your original hsqldb ODB file whether the Advanced Property ODBC
compliant strings is ticked - if it is, deactivate it and then try the
migration to Firebird ;

- check the Advanced Properties of your Firebird database to see whether this
option is also present, and try switching it off.

If you can't find these properties under the Advanced Properties dialog of the
ODB, try setting them via the Advanced Configuration tool (if at all possible).
Quite frankly IMO, the whole "removing the Advanced Properties" dialog by the
UI/UX group to make the UI easier to use was a completely pointless exercise,
and only serves to frustrate database admins.

-- 
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/20190528/23edb125/attachment.html>