<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125162#c20">Comment # 20</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125162">bug 125162</a> from <a class="email" href="mailto:silvain-dupertuis@bluewin.ch" title="Silvain Dupertuis <silvain-dupertuis@bluewin.ch>"> Silvain Dupertuis</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>