[jira] [Created] (DRILL-7050) RexNode convert exception in subquery

[Oleg Zinoviev (JIRA)]

Oleg Zinoviev created DRILL-7050:
------------------------------------

             Summary: RexNode convert exception in subquery
                 Key: DRILL-7050
                 URL: https://issues.apache.org/jira/browse/DRILL-7050
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.15.0, 1.14.0
            Reporter: Oleg Zinoviev


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)
```sql
create table dfs.root.source as  (
    select 1 as id union all select 2 as id
)
```
2) Execute query
```sql
select t1.id,
        (select count(t2.id) 
        from storage.datasets.source t2 where t2.id = t1.id)
from storage.datasets.source t1
```

Reason: 

Method ```org.apache.calcite.sql2rel.SqlToRelConverter.Blackboard.lookupExp```  
call ```RexBuilder.makeCorrel``` in some cases




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)