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