[jira] [Created] (CALCITE-3244) Decorrelating sub-queries - Adding Implicit RowID support

["benj (JIRA)" <ji...@apache.org>]

benj created CALCITE-3244:
-----------------------------

             Summary: Decorrelating sub-queries - Adding Implicit RowID support
                 Key: CALCITE-3244
                 URL: https://issues.apache.org/jira/browse/CALCITE-3244
             Project: Calcite
          Issue Type: Improvement
    Affects Versions: 1.20.0
            Reporter: benj


Some very useful type of requests currently failed with:
{code:java}
SYSTEM ERROR: UnsupportedOperationException: Adding Implicit RowID column is not supported for ValuesPrel operator 
{code}
Examples from DRILL-7050:
{code:sql}
select t1.id,
     (select count(t2.id) 
     from (
         select 1 as id 
         union all 
         select 2 as id
     ) t2 where t2.id = t1.id)
 from (
     select 1 as id 
     union all 
     select 2 as id
 ) t1
{code}
{code:sql}
SELECT t,
(SELECT count(*) FROM
 (SELECT split(r,' ') AS r FROM
  (SELECT sub.t AS r)) AS x
 ,LATERAL(SELECT $unnest AS u FROM unnest(x.r))
 /* WHERE ... */) t2
FROM
(SELECT 'unnest is useful' AS t) sub
{code}
 

_Please note that in 1.18 the error for these requests was:_
{code:java}
Error: PLAN ERROR: Cannot convert RexNode to equivalent Drill expression. RexNode Class: org.apache.calcite.rex.RexCorrelVariable, RexNode Digest: $cor0
{code}



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)