Error1: Data could not be loaded dbtools.cxx:751 / Error2: Firebird_sdbc, SQL error code=804

[SteveSteve]

After installing (and re-installing) some expansions (shame on me, literally can’t recall which they were!) I am unable to load my query again. Can somebody help? It took me now the whole day, but I have no Idea how to solve that…Thanks

Die Dateninhalte konnten nicht geladen werden. (Data could not be loaded)
./connectivity/source/commontools/dbtools.cxx:751

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -804
*Function unknown
*IFNULL
caused by
‘isc_dsql_prepare’
./connectivity/source/drivers/firebird/Util.cxx:68

[RobertG]

Function IFNULL doesn’t exist in Firebird. Use COALESCE instead. works also with internal HSQLDB.

You could use COALESCE for many different expressions, which are proofed against NULL:

COALESCE(expr1,expr2,expr3,...,value)

[SteveSteve]

Thank you Robert,
the only help was to copy paste the content of one database to a “fresh” one linked to HSQLDB… Not sure where the error came, but must have been from one installed extension, somehow it linked to firebird automatically. Bug or my fault? I can’t recall

[RobertG]

Seems you have switched experimental features to “on”. Then the migration tool for Firebird will as, if the HSQLDB database should be migrated to Firebird. If you are using databases switch the experimental features to “off”.

When changing with the migration tool from HSQLDB to Firebird it will be good to have a look at Firebird Migration. There are a lot of functions, which are special HSQLB functions. You could change to functions, which will do the same and will work in HSQLDB and Firebird.

Most SQL-errors are errors in queries and views. So you have to open this parts to see if there is used “IFNULL”.