[TAJO-891] Complex join conditions with UNION or inline should be supported

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: distributed query plan, Planner/Optimizer
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 26/Jun/14 10:10
• Updated: 03/Jul/14 14:04
• Resolved: 03/Jul/14 13:53

Description

Please see the following two example queries. Currently, they will cause planning exception. This patch fixes the bugs.

select
  n1.n_nationkey,
  substr(n1.n_name, 1, 4) name1,
  substr(n2.n_name, 1, 4) name2
from nation n1 join (select * from nation) n2 on substr(n1.n_name, 1, 4) = substr(n2.n_name, 1, 4)
order by n1.n_nationkey;

select
  n1.n_nationkey,
  substr(n1.n_name, 1, 4) name1,
  substr(n2.n_name, 1, 4) name2
from nation n1 join (select * from nation union select * from nation) n2 on substr(n1.n_name, 1, 4) = substr(n2.n_name, 1, 4)
order by n1.n_nationkey;