[DRILL-5644] Projection using a scalar subquery causes zero rows to be returned by statement

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Server

Environment

Drill 1.10

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 30/Jun/17 21:20
• Updated: 30/Jun/17 21:20

Description

When C3 is included in the projection zero rows are returned versus the expected 3 rows

select TJOIN1.RNUM, TJOIN1.C1, case when 10 in ( select C1 from ( values (1) ) T(C1) ) then 'yes' else 'no' end C3 from
(
values
( 0, 10, 15),
( 1, 20, 25),
( 2, cast(NULL as integer), 50)
) TJOIN1 (RNUM, C1, C2)