Submitted By: jthaddeus
GPRE does not recognize the COALESCE function. Upon
reaching the COALESCE line in any code I've tried, an
error is thrown. For example:
$ /opt/firebird/bin/gpre -c -n -m o_process.e
(E) o_process.e:234: expected FROM, encountered "("
(E) o_process.e:302: expected FROM, encountered "("
2 errors, no warnings
Platform: SuSE Linux 9.0
Firebird installed with:
For the error above, line 234, looks like
232 EXEC SQL
234 procid, COALESCE(procname,' '), wfmcstate,
I have also tried
234 procid, COALESCE(procname,' ') as procname,
with similar results.
COALESCE works in ISQL.
The attached file demonstrates the error in a program
written against the employee.fdb. Instructions are in
the file's comments.
NOTE: I have not tired NULLIF or any other function in
ESQL (I've been using my own UDF for NULLIF and
NVL/COALESCE with Firebird 1.0.x).