[jira] [Updated] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Summary: Decorrelate will fail. If the RelNode tree has LogicalValues (was: Decorrelate will fail. I

[jira] [Updated] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has logicvalue

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has logicvalue

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has logicvalue

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Summary: Decorrelate will fail. If the RelNode tree has logicvalue (was: LogicalValues causes decorr

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Commented] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698896#comment-17698896 ] libopeng commented on CALCITE-5568: --- [~FrankZou] Case has been added, please check >

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description: {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Updated] (CALCITE-5568) LogicalValues causes decorrelate to fail

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5568: -- Description:   {code:java} SELECT ( SELECT ( SUM ( "tbl2"."count" ) ) AS "SUM" FROM

[jira] [Created] (CALCITE-5568) LogicalValues causes decorrelate to fail

libopeng created CALCITE-5568: - Summary: LogicalValues causes decorrelate to fail Key: CALCITE-5568 URL: https://issues.apache.org/jira/browse/CALCITE-5568 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-5420) SqlToRel should populate the correlate id of a Project for queries with aggregates

[ https://issues.apache.org/jira/browse/CALCITE-5420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695734#comment-17695734 ] libopeng commented on CALCITE-5420: --- [CALCITE-5544|https://issues.apache.org/jira/pro

[jira] [Closed] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will make

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng closed CALCITE-5544. - Resolution: Duplicate > SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an >

[jira] [Commented] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will ma

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693789#comment-17693789 ] libopeng commented on CALCITE-5544: --- [~libenchao] I see. I'll try to fix it > SCALAR

[jira] [Commented] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will ma

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693767#comment-17693767 ] libopeng commented on CALCITE-5544: --- [~libenchao] I probably see what you mean, the "

[jira] [Comment Edited] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel wi

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693639#comment-17693639 ] libopeng edited comment on CALCITE-5544 at 2/27/23 2:43 AM:

[jira] [Commented] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will ma

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693639#comment-17693639 ] libopeng commented on CALCITE-5544: --- I think these two cases are not the same, althou

[jira] [Updated] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will make

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5544: -- Summary: SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative sub

[jira] [Created] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will fail

libopeng created CALCITE-5544: - Summary: SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will fail Key: CALCITE-5544

[jira] [Updated] (CALCITE-5544) SCALAR_QUERY is nested within SCALAR_QUERY, and the inner SCALAR_QUERY is an associative subquery that references a variable of the external query, sql to rel will fail

[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5544: -- Description:   {code:java} SELECT     *,     (     SELECT SUM         ( (SELECT SUM ( order_amt ) FRO

<    1   2