You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "LakeShen (Jira)" <ji...@apache.org> on 2023/07/16 12:38:00 UTC

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

    [ https://issues.apache.org/jira/browse/CALCITE-5847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743523#comment-17743523 ] 

LakeShen edited comment on CALCITE-5847 at 7/16/23 12:37 PM:
-------------------------------------------------------------

Hi [~libenchao] ,

I tested it with CALCITE-5568's PR code,after the RelDecorrelator.decorrelateQuery method,LogicalCorrelate still exist.

I think that they shouldn't be the same problem.


was (Author: shenlang):
Hi [~libenchao] ,

I testes it with CALCITE-5568's PR code,after the RelDecorrelator.decorrelateQuery method,LogicalCorrelate still exist.

I think that they shouldn't be the same problem.

> The sql which has Values and CROSS JOIN unnest,after the RelDecorrelator.decorrelateQuery method,LogicalCorrelate still exist
> -----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-5847
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5847
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.34.0
>            Reporter: LakeShen
>            Priority: Major
>
> The Sql is :
> {code:java}
> SELECT val FROM (SELECT DISTINCT vals FROM (values (array[2])) t(vals) WHERE false) tmp CROSS JOIN unnest(tmp.vals) tt(val) {code}
> Before the  RelDecorrelator.decorrelateQuery method,the sql plan above is:
> {code:java}
> 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 }]]) {code}
> After the  RelDecorrelator.decorrelateQuery method,the sql plan above is:
> {code:java}
> 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 }]]){code}
> LogicalCorrelate has not been eliminated
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)