Submitted by: robur.6 (robur.6)

Duplicates CORE1246
Block progress on CORE3354

Given:
- a left join
- the right table part is a subquery containing an expression
- that expresion does not reference any column (e.g. a constant or current_time)

The result contains the expression value instead of null if there is no matching row in the right table.

CREATE TABLE TEST (
FIELD INTEGER
);

insert into test values(1);
insert into test values(2);

select * from
test t1
left join
(
select field, 'x' expression from test
where field=1
) t2
on t1.field=t2.field
;

Result:

   FIELD        FIELD EXPRESSION

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

Expected result:

   FIELD        FIELD EXPRESSION

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