Hi Claudio, > After reading Adriano's mail, I stopped looking at v2.5. > :-)
> I think the case can be summarized and optimized: > given > T = table > V = the result of a selectable proc, view or derived table, > if T left join V produces a null record in V caused by a non-matching > outer > join, > then coalesce() in V should produce null immediately, no need to evaluate > the arguments. Exactly. >> Simplified test case: > ... > Strange, I get NULL and NULL in v2.5 and v3. lol, i tested on a older version. Problem of having to many different versions on your computer around. So this one was fixed already. Kind Regards, Arno Brinkman ABVisie ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel