[CALCITE-5847] The sql which has Values and CROSS JOIN unnest,after the RelDecorrelator.decorrelateQuery method,LogicalCorrelate still exist

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.34.0
• Component/s: core
• Assignee: Unassigned
• Reporter: LakeShen
• Created: 14/Jul/23 09:11
• Updated: 16/Jul/23 12:37

Description

The Sql is :

SELECT val FROM (SELECT DISTINCT vals FROM (values (array[2])) t(vals) WHERE false) tmp CROSS JOIN unnest(tmp.vals) tt(val) 

Before the  RelDecorrelator.decorrelateQuery method,the sql plan above is:

LogicalProject(val=[$1])
  LogicalCorrelate(correlation=[$cor0], joinType=[inner], requiredColumns=[{0}])
    LogicalProject(vals=[$0])
      LogicalFilter(condition=[false])
        LogicalProject(vals=[ARRAY(2)])
          LogicalValues(tuples=[[{ 0 }]])
    LogicalProject(val=[$0])
      Uncollect
        LogicalProject(vals=[$cor0.vals])
          LogicalValues(tuples=[[{ 0 }]]) 

After the  RelDecorrelator.decorrelateQuery method,the sql plan above is:

LogicalProject(val=[$1])
  LogicalCorrelate(correlation=[$cor0], joinType=[inner], requiredColumns=[{0}])
    LogicalProject(vals=[$0])
      LogicalProject(vals=[ARRAY(2)])
        LogicalFilter(condition=[false])
          LogicalValues(tuples=[[{ 0 }]])
    LogicalProject(val=[$0])
      Uncollect
        LogicalProject(vals=[$cor0.vals])
          LogicalValues(tuples=[[{ 0 }]])

LogicalCorrelate has not been eliminated