Hi Claudio, Simplified test case:
SELECT dt.* FROM RDB$DATABASE LEFT JOIN (SELECT COALESCE(RDB$SECURITY_CLASS, 'NO WAY') AS COALESCE_RET, 'YES THIS TO' AS CONST_RET FROM RDB$DATABASE WHERE 1=1) dt ON (1 = 0); Result: COALESCE_RET CONST_RET --------------------------------------------------------------------------------------------------------- NO WAY YES THIS TO I've to dig deep in my memory (ooh boy), but i think the stream flag NULL is not treated proper in this case. Thinking i've fixed something simular or even this in the past, but seems not :-/ Kind Regards, Arno Brinkman ABVisie ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
