Submitted by: Smirnoff Serg (wildsery)

Relate to CORE3176
Relate to CORE3173
Is related to QA443

Votes: 2

Test case:

recreate table test_err (id int);
insert into test_err (ID) values (1);
insert into test_err (ID) values (2);

select *
from test_err t
left join (select 1 id from rdb$database) a on http://a.id = http://t.id;

Result must be
ID ID
============ ============
1 1
2 <null>

But, result is
ID ID
============ ============
1 <null>
2 <null>

However, the second LEFT JOIN works fine
select *
from test_err t
left join (select 1 id from rdb$database) a on http://a.id = http://t.id
left join (select 2 id from rdb$database) b on http://b.id = http://t.id;

      ID           ID           ID

============ ============ ============
1 <null> <null>
2 <null> 2

Commits: 70ad7ef a539537 7f3dc62 ea94b62