https://bugs.documentfoundation.org/show_bug.cgi?id=125162
--- Comment #20 from Silvain Dupertuis <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
