Submitted by: Ugur Soyan (ugrsyn)

Is duplicated by CORE5149
Duplicates CORE5149

create table master(id integer not null primary key, x integer);
create table trn(id integer not null primary key, master_id integer);

insert into master(id,x) values(1,0);
insert into master(id,x) values(2,null);
insert into master(id,x) values(3,1);

insert into trn(id,master_id) values(1,1);
insert into trn(id,master_id) values(2,1);
insert into trn(id,master_id) values(3,2);
insert into trn(id,master_id) values(4,2);
insert into trn(id,master_id) values(5,3);
insert into trn(id,master_id) values(6,3);
insert into trn(id,master_id) values(7,3);

------------
Select http://t.id trn_id, t.master_id trn_master_id, http://m.id master_id, m.x
from trn t
left outer join master m on http://m.id = t.master_id
where coalesce( m.x ,0 ) = 0
------------

--- Firebird 2.5 Result ---

TRN_ID | TRN_MASTER_ID | MASTER_ID | X
------------------------------------------
1 | 1 | 1 | 0
2 | 1 | 1 | 0
3 | 2 | 2 |(null)
4 | 2 | 2 |(null)
------------------------------------------

--- Firebird 3 RC Result ---

TRN_ID | TRN_MASTER_ID | MASTER_ID | X
------------------------------------------
1 | 1 | 1 | 0
2 | 1 | 1 | 0
3 | 2 | 2 |(null)
4 | 2 | 2 |(null)
5 | 3 |(null) |(null)
6 | 3 |(null) |(null)
7 | 3 |(null) |(null)
------------------------------------------

====== Test Details ======

See test for core-5149