Incorrect result with VIEW and COALESCE [CORE4959]

[firebird-automations]

Submitted by: Shiliaev Ruslan (shiliaevruslan)

Test case:

CREATE VIEW V(F1, F2) AS SELECT RDB$SECURITY_CLASS, COALESCE(RDB$SECURITY_CLASS , 'B') FROM RDB$DATABASE WHERE 1=0;

SELECT 1, V.F1, V.F2 FROM RDB$DATABASE LEFT JOIN V ON 1=0;

CONSTANT 1 F1 <null> F2 B --?????