[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 #16 from Silvain Dupertuis <silvain-dupertuis at bluewin.ch> ---
With my present version (6.3.5.2 on Ubuntu 18.04), I no longer see any tool to
migrate to Firebird and the migration is no longer suggested at start-up of a
base document.

As for the problem I had with migration, I did find some workaround for the 3
things that prevented me to migrate. But it is still a lot of work:
1) get rid of all the {oj...} in the syntax of queries like "FROM { oj "Table1"
LEFT OUTER JOIN "Table2"...}" - HSQL understand the query without the {oj} but
stubbornly adds them when saving the query.
2) replace all the "CONCAT( aaa , bbb )" by the syntax "aaa || bbb"
3) replace the code I had made to output 1 or 0 in a complex query to check if
one person is in a list (where the relationship is defined by a intermediate
table to have a many to many relationship between lists and persons), so as to
display which list a persons belongs to in a form. I had used a code with
CONCAT to calculate this 0 or 1, and I can replace it with a CASE syntax (which
works in both HSQL and Firebird)
The good thing is that for points 2) and 3), the new syntax valid for Firebird
works also for HSQL

-- 
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/20200407/80e00bd2/attachment.htm>