[TAJO-867] OUTER JOIN with empty result subquery produces a wrong result.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Assignee: Hyoungjun Kim
• Reporter: Hyoungjun Kim
• Created: 05/Jun/14 12:41
• Updated: 27/Jun/14 05:35
• Resolved: 27/Jun/14 05:10

Description

In the following query if a subquery has no data, a Execution block for final outer join has only one task and final result is wrong.

select * 
from table1 a
outer join (select * from table2 where code = '1') b
on a.id = b.id