[DRILL-4105] Constant Folding and coalesce function with 3 parameters gives cannot plan exception

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.0
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 17/Nov/15 18:18
• Updated: 17/Nov/15 18:19

Description

git.commit.id.abbrev=447f8ba

The below query results in a cannot plan exception

select * from cp.`tpch/lineitem.parquet` d1, cp.`tpch/lineitem.parquet` d2 where d1.l_comment = coalesce(d2.l_comment, 'asdf', d2.l_comment);
Error: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join


[Error Id: d0b75ac0-6d39-4fb0-bc48-13e52fa4abf2 on qa-node190.qa.lab:31010] (state=,code=0)

However the query executes fine if I disabled constant folding.