COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match [CORE2660]

[firebird-automations]

Submitted by: @asfernandes

Is related to QA418

select b.*
from rdb$database a
left join (
select count(*) c
from rdb$database
) b on 1 = 0;

       C 

============
0

It should return NULL.

Commits: 0ca8706 d626605 FirebirdSQL/fbt-repository@08eef16

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC1 [ 10362 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA418 [ QA418 ]

[firebird-automations]

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully