[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 #20 from Silvain Dupertuis <silvain-dupertuis at bluewin.ch> ---
I have prepared some REGEX transformation commands to solve the problems I have
encountered so that I could made most of the adaptations by handling the
internal text files of the ZIP odb file.

A - In queries and views - and the new queries all work fine in HSQLBD
1) get rid of the additional {of .... } in queries with OUTER JOIN
2) replace the CONCAT(X, CONCAT(' ', Y) form by X || ' ' || Y
3) replace the formulas I had found to display if somebody is in a list in a
many-to-many relationships defined by an intermediate table by something of the
kind
(CASE WHEN ... IS NULL THEN '–' ELSE '✓' END)

B - In Table descriptions
4) replace VARCHAR_IGNORECASE(n) by VARCHAR(n)
5) replace TIMESTAMP(0) by TIMESTAMP

It seems to me that these transfomrations (except #3) could be handled by the
migration tool.

If anyone is interested, I can share these REGEX (which still needs checking,
as I have tested them on one Database only, but the most complex one I have,
and only as a preliminary test before I migrate the actuel Database used.

-- 
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/20200511/1271441e/attachment.htm>