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

2024-08-28 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877516#comment-17877516 ] Ian Bertolacci commented on CALCITE-6554: - Tested and it seems to work: https:

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

2024-08-28 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877507#comment-17877507 ] Ian Bertolacci commented on CALCITE-6554: - I do wonder if this is correct when

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

2024-08-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6554: Labels: pull-request-available (was: ) > nested correlated sub-query in aggregation does

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

2024-08-28 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877496#comment-17877496 ] Ian Bertolacci commented on CALCITE-6554: - [~libenchao] Would it make sense for

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

2024-08-28 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877496#comment-17877496 ] Ian Bertolacci edited comment on CALCITE-6554 at 8/28/24 6:46 PM: ---

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

2024-08-28 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci reassigned CALCITE-6554: --- Assignee: Ian Bertolacci > nested correlated sub-query in aggregation does not hav

[jira] [Commented] (CALCITE-5213) PROJECT_TO_SUBQUERY producing Incorrect tree from nested correlated subqueries in projections with correlations in filters.

2024-08-28 Thread Ian Bertolacci (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877494#comment-17877494 ] Ian Bertolacci commented on CALCITE-5213: - It looks like there is still an issu

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

2024-08-28 Thread Ian Bertolacci (Jira)
Ian Bertolacci created CALCITE-6554: --- Summary: nested correlated sub-query in aggregation does not have inner correlation variable bound to inner projection Key: CALCITE-6554 URL: https://issues.apache.org/jira/

[jira] [Created] (CALCITE-6553) In server, several CREATE and DROP commands are incorrect if schema does not exist

2024-08-28 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6553: Summary: In server, several CREATE and DROP commands are incorrect if schema does not exist Key: CALCITE-6553 URL: https://issues.apache.org/jira/browse/CALCITE-6553

[jira] [Commented] (CALCITE-6552) Enable CheckerFramework in 'server' module

2024-08-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877469#comment-17877469 ] Julian Hyde commented on CALCITE-6552: -- I logged CALCITE-6553 for some remaining w

[jira] [Updated] (CALCITE-6552) Enable CheckerFramework in 'server' module

2024-08-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6552: - Fix Version/s: 1.38.0 > Enable CheckerFramework in 'server' module > --

[jira] [Updated] (CALCITE-6552) Enable CheckerFramework in 'server' module

2024-08-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6552: Labels: pull-request-available (was: ) > Enable CheckerFramework in 'server' module > --

[jira] [Updated] (CALCITE-6552) Enable checkerframework in 'server' module

2024-08-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6552: - Description: In CALCITE-4199 we enabled CheckerFramework (via annotations and CI jobs) in the

[jira] [Updated] (CALCITE-6552) Enable CheckerFramework in 'server' module

2024-08-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6552: - Summary: Enable CheckerFramework in 'server' module (was: Enable checkerframework in 'server'

[jira] [Assigned] (CALCITE-6552) Enable checkerframework in 'server' module

2024-08-28 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6552: Assignee: Julian Hyde > Enable checkerframework in 'server' module > ---

[jira] [Created] (CALCITE-6552) Enable checkerframework in 'server' module

2024-08-28 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-6552: Summary: Enable checkerframework in 'server' module Key: CALCITE-6552 URL: https://issues.apache.org/jira/browse/CALCITE-6552 Project: Calcite Issue Type: Im

[jira] [Updated] (CALCITE-6551) Add DATE_FORMAT function (enabled in MySQL library)

2024-08-28 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6551: Labels: pull-request-available (was: ) > Add DATE_FORMAT function (enabled in MySQL libr

[jira] [Assigned] (CALCITE-6551) Add DATE_FORMAT function (enabled in MySQL library)

2024-08-28 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6551: -- Assignee: suibianwanwan > Add DATE_FORMAT function (enabled in MySQL library) >

[jira] [Created] (CALCITE-6551) Add DATE_FORMAT function (enabled in MySQL library)

2024-08-28 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6551: -- Summary: Add DATE_FORMAT function (enabled in MySQL library) Key: CALCITE-6551 URL: https://issues.apache.org/jira/browse/CALCITE-6551 Project: Calcite I

[jira] [Commented] (CALCITE-6550) Improve SQL function overloading

2024-08-28 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877446#comment-17877446 ] Caican Cai commented on CALCITE-6550: - Some functions in different dialects only ha

[jira] [Commented] (CALCITE-6550) Improve SQL function overloading

2024-08-28 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877442#comment-17877442 ] Caican Cai commented on CALCITE-6550: - There is another issue to consider here. If