[DRILL-7050] RexNode convert exception in subquery

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0, 1.15.0
• Fix Version/s: 1.17.0
• Labels: ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Oleg Zinoviev
• Reviewer: Arina Ielchiieva
• Created: 22/Feb/19 15:39
• Updated: 02/Oct/19 18:38
• Resolved: 04/May/19 02:21

Description

If the query contains a subquery whose filters are associated with the main query, an error occurs: PLAN ERROR: Cannot convert RexNode to equivalent Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable

Steps to reproduce:
1) Create source table (or view, doesn't matter)

create table dfs.root.source as  (
    select 1 as id union all select 2 as id
)

2) Execute query

select t1.id,
	(select count(t2.id) 
	from dfs.root.source t2 where t2.id = t1.id)
from  dfs.root.source t1

Reason:

Method

org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp

call

RexBuilder.makeCorrel

in some cases

Issue Links

• Dependent: CALCITE-2954 SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id
• links to: GitHub Pull Request #1770