Hello:

I'm having problems using COALESCE with NUMERIC and DECIMAL data types,
on isc_dsql_describe, in a sample like this, tested using the .NET
Provider and
Firebird 1.5:

SELECT * FROM TEST where ((NUMERIC_FIELD IS NULL AND COALESCE(?,
CAST(NULL AS NUMERIC)) IS NULL) OR (NUMERIC_FIELD = ?))

The first parameter is decribed as integer and the second as
numeric/decimal,
this works well in all other data types where both parameters are desribed
with the same data type (the only ones i haven't checked are
blobs and arrays).


Is this the expected behavior ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain