[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&focusedCommentId=17693601#comment-17693601 ] Benchao Li commented on CALCITE-5506: - We still have a dummy {{COUNT}} after field

[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 when

[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 incorr

[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 re

[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&focusedCommentId=17693639#comment-17693639 ] libopeng commented on CALCITE-5544: --- I think these two cases are not the same, althou

[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&focusedCommentId=17693639#comment-17693639 ] libopeng edited comment on CALCITE-5544 at 2/27/23 2:43 AM:

[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] [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&focusedCommentId=17693767#comment-17693767 ] libopeng commented on CALCITE-5544: --- [~libenchao] I probably see what you mean, the "

[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&focusedCommentId=17693771#comment-17693771 ] Tanner Clary commented on CALCITE-5464: --- Closed in [cb97d29|https://github.com/a

[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&focusedCommentId=17693784#comment-17693784 ] Benchao Li commented on CALCITE-5544: - [~leepb] Yes, there are two ways to handle s

[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&focusedCommentId=17693789#comment-17693789 ] libopeng commented on CALCITE-5544: --- [~libenchao] I see. I'll try to fix it > SCALAR