[jira] [Updated] (CALCITE-6516) AVG to SUM+COUNT transformation inserts invalid CAST call

2024-08-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6516: Labels: pull-request-available (was: ) > AVG to SUM+COUNT transformation inserts invalid

[jira] [Commented] (CALCITE-6516) AVG to SUM+COUNT transformation inserts invalid CAST call

2024-08-29 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877683#comment-17877683 ] Leonid Chistov commented on CALCITE-6516: - [~julianhyde]  I haven't found any

[jira] [Commented] (CALCITE-6516) AVG to SUM+COUNT transformation inserts invalid CAST call

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877757#comment-17877757 ] Mihai Budiu commented on CALCITE-6516: -- This was discussed here: https://issues.a

[jira] [Commented] (CALCITE-6516) AVG to SUM+COUNT transformation inserts invalid CAST call

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1787#comment-1787 ] Mihai Budiu commented on CALCITE-6516: -- I take back my last comment, it's not rele

[jira] [Resolved] (CALCITE-6508) Parse error when using scalar sub-query as operand to Array constructor function

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6508. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in https://github.com/apache/calcite/co

[jira] [Updated] (CALCITE-6508) Parse error when using scalar sub-query as operand to Array constructor function

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6508: - Priority: Minor (was: Major) > Parse error when using scalar sub-query as operand to Array con

[jira] [Updated] (CALCITE-5613) Add assert for number of args for metadata methods at CacheGeneratorUtil

2024-08-29 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5613: Labels: pull-request-available (was: ) > Add assert for number of args for metadata meth

[jira] [Created] (CALCITE-6555) RelBuilder.aggregateRex thinks aggregate functions of "GROUP BY ()" queries are NOT NULL

2024-08-29 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6555: Summary: RelBuilder.aggregateRex thinks aggregate functions of "GROUP BY ()" queries are NOT NULL Key: CALCITE-6555 URL: https://issues.apache.org/jira/browse/CALCITE-6555

[jira] [Created] (CALCITE-6556) Return Data Type of CASE Statement is Incorrect

2024-08-29 Thread Karamsetty Vishnu vardhan (Jira)
Karamsetty Vishnu vardhan created CALCITE-6556: -- Summary: Return Data Type of CASE Statement is Incorrect Key: CALCITE-6556 URL: https://issues.apache.org/jira/browse/CALCITE-6556 Project:

[jira] [Resolved] (CALCITE-5613) Add assert for number of args for metadata methods at CacheGeneratorUtil

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-5613. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in https://github.com/apache/calcite/co

[jira] [Commented] (CALCITE-6556) Return Data Type of CASE Statement is Incorrect

2024-08-29 Thread Karamsetty Vishnu vardhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877886#comment-17877886 ] Karamsetty Vishnu vardhan commented on CALCITE-6556: can i take thi

[jira] [Commented] (CALCITE-6556) Return Data Type of CASE Statement is Incorrect

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877888#comment-17877888 ] Mihai Budiu commented on CALCITE-6556: -- BIGINT instances should not have a precisi

[jira] [Commented] (CALCITE-6556) Return Data Type of CASE Statement is Incorrect

2024-08-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877889#comment-17877889 ] Mihai Budiu commented on CALCITE-6556: -- So it depends probably of the type system

[jira] [Commented] (CALCITE-6508) Parse error when using scalar sub-query as operand to Array constructor function

2024-08-29 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877899#comment-17877899 ] Ian Bertolacci commented on CALCITE-6508: - Happy to help! Its nice to finally b

[jira] [Commented] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

2024-08-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877906#comment-17877906 ] Julian Hyde commented on CALCITE-6554: -- Looks good. I don't recall whether the Qu

[jira] [Updated] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

2024-08-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6554: - Fix Version/s: 1.38.0 > nested correlated sub-query in aggregation does not have inner correlat

[jira] [Comment Edited] (CALCITE-6554) nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection

2024-08-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877906#comment-17877906 ] Julian Hyde edited comment on CALCITE-6554 at 8/29/24 10:33 PM: -

[jira] [Assigned] (CALCITE-6555) RelBuilder.aggregateRex thinks aggregate functions of "GROUP BY ()" queries are NOT NULL

2024-08-29 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6555: Assignee: Julian Hyde > RelBuilder.aggregateRex thinks aggregate functions of "GROUP BY

[jira] [Commented] (CALCITE-6516) AVG to SUM+COUNT transformation inserts invalid CAST call

2024-08-29 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877930#comment-17877930 ] suibianwanwan commented on CALCITE-6516: Also, in all the databases I've tested

[jira] [Commented] (CALCITE-6556) Return Data Type of CASE Statement is Incorrect

2024-08-29 Thread Karamsetty Vishnu vardhan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877968#comment-17877968 ] Karamsetty Vishnu vardhan commented on CALCITE-6556: in calcite , t