Queries containing … FROM { oj “leftTable” LEFT OUTER JOIN “rightTable” …} stop with:
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 71
*“leftTable” caused by ‘isc_dsql_prepare’
Removing
{ oj
and its closing bracket } resolves the issue.
This is not unique to LO with Firebird: https://mariadb.atlassian.net/browse/CONJ-106