[Libreoffice-bugs] [Bug 125162] SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon May 11 16:32:41 UTC 2020
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>
More information about the Libreoffice-bugs
mailing list