[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

2023-02-26 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693789#comment-17693789 ] libopeng commented on CALCITE-5544: --- [~libenchao] I see. I'll try to fix it > SCALAR_QUERY is nested

[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

2023-02-26 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693784#comment-17693784 ] Benchao Li commented on CALCITE-5544: - [~leepb] Yes, there are two ways to handle sub-queries now,

[jira] [Resolved] (CALCITE-5464) Implement BigQuery DATE_ADD/DATE_DIFF

2023-02-26 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-5464. --- Resolution: Fixed > Implement BigQuery DATE_ADD/DATE_DIFF >

[jira] [Commented] (CALCITE-5464) Implement BigQuery DATE_ADD/DATE_DIFF

2023-02-26 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693771#comment-17693771 ] Tanner Clary commented on CALCITE-5464: --- Closed in

[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

2023-02-26 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693767#comment-17693767 ] libopeng commented on CALCITE-5544: --- [~libenchao] I probably see what you mean, the "expand" ability

[jira] [Updated] (CALCITE-5435) Insert for multi row VALUES failed when column has values of different types

2023-02-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5435: Labels: pull-request-available (was: ) > Insert for multi row VALUES failed when column

[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

2023-02-26 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693639#comment-17693639 ] libopeng edited comment on CALCITE-5544 at 2/27/23 2:43 AM: [~libenchao] I

[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

2023-02-26 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693639#comment-17693639 ] libopeng commented on CALCITE-5544: --- I think these two cases are not the same, although they can be

[jira] [Updated] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic

2023-02-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5506: Summary: RelToSqlConverter should retain the aggregation logic (was: RelToSqlConverter should

[jira] [Updated] (CALCITE-5530) RelToSqlConverter[ORDER BY] generates an incorrect field alias when 2 projection fields have the same name

2023-02-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5530: Labels: pull-request-available (was: ) > RelToSqlConverter[ORDER BY] generates an

[jira] [Assigned] (CALCITE-5530) RelToSqlConverter[ORDER BY] generates an incorrect field alias when 2 projection fields have the same name

2023-02-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5530: --- Assignee: Jiajun Xie > RelToSqlConverter[ORDER BY] generates an incorrect field alias

[jira] [Commented] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic even if the aggregation function is trimmed

2023-02-26 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693601#comment-17693601 ] Benchao Li commented on CALCITE-5506: - We still have a dummy {{COUNT}} after field trimming, right?