[jira] [Comment Edited] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735957#comment-17735957 ] Jiajun Xie edited comment on CALCITE-5688 at 6/22/23 3:06 AM: -- I

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5688: Description: Calcite should support parse truncate syntax like SQL2011 {code:java} ::=  

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735957#comment-17735957 ] Jiajun Xie commented on CALCITE-5688: - I implement it in the server module and change the Jira

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5688: Component/s: server (was: babel) (was: core) > Support

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5688: Issue Type: Improvement (was: Task) Summary: Support TRUNCATE TABLE DDL statement in

[jira] [Updated] (CALCITE-5793) Use NULLS FIRST / LAST when unparsing in BigQuery

2023-06-21 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5793: Labels: pull-request-available (was: ) > Use NULLS FIRST / LAST when unparsing in

[jira] [Commented] (CALCITE-5775) Null direction emulation broken for complex expressions on some dialects

2023-06-21 Thread Will Noble (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735913#comment-17735913 ] Will Noble commented on CALCITE-5775: - Filed CALCITE-5793. Calcite already is so inclined to group

[jira] [Resolved] (CALCITE-5792) Update dependencies to latest version

2023-06-21 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-5792. - Resolution: Fixed > Update dependencies to latest version >

[jira] [Created] (CALCITE-5793) Use NULLS FIRST / LAST when unparsing in BigQuery

2023-06-21 Thread Will Noble (Jira)
Will Noble created CALCITE-5793: --- Summary: Use NULLS FIRST / LAST when unparsing in BigQuery Key: CALCITE-5793 URL: https://issues.apache.org/jira/browse/CALCITE-5793 Project: Calcite Issue

[jira] [Comment Edited] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

2023-06-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735902#comment-17735902 ] Julian Hyde edited comment on CALCITE-5724 at 6/21/23 9:14 PM: --- Oh, maybe

[jira] [Commented] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

2023-06-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735902#comment-17735902 ] Julian Hyde commented on CALCITE-5724: -- Oh, maybe that wasn't a conflict. In the {{orderField}}

[jira] [Commented] (CALCITE-5724) Generated SQL uses literal values in ORDER BY clauses

2023-06-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735887#comment-17735887 ] Julian Hyde commented on CALCITE-5724: -- [~jhugomoore], Can you please rebase on latest main, and

[jira] [Commented] (CALCITE-5479) FamilyOperandTypeChecker is not readily composable in sequences

2023-06-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735852#comment-17735852 ] Julian Hyde commented on CALCITE-5479: -- I recall having the following issue. I want to check that

[jira] [Commented] (CALCITE-5785) The :babel:fmppMain and :server:fmppMain tasks currently do not work with Gradle remote build caching

2023-06-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735845#comment-17735845 ] Julian Hyde commented on CALCITE-5785: -- I would chalk this up to test flakiness. I ran the whole

[jira] [Commented] (CALCITE-5791) DDL commands ceased to work in 1.23-1.24 transition

2023-06-21 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735844#comment-17735844 ] Julian Hyde commented on CALCITE-5791: -- [~josefspillner], Sounds like you might have an invalid

[jira] [Commented] (CALCITE-5791) DDL commands ceased to work in 1.23-1.24 transition

2023-06-21 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735822#comment-17735822 ] Mihai Budiu commented on CALCITE-5791: -- Our project has been using DDL recently with no problems

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Resolved] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5751. - Resolution: Fixed > Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark

[jira] [Commented] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-21 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735712#comment-17735712 ] Jiajun Xie commented on CALCITE-5751: - Fixed in

[jira] [Assigned] (CALCITE-5792) Update dependencies to latest version

2023-06-21 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang reassigned CALCITE-5792: --- Assignee: Parag Jain (was: Francis Chuang) > Update dependencies to latest

[jira] [Updated] (CALCITE-5792) Update dependencies to latest version

2023-06-21 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-5792: Fix Version/s: avatica-go-5.3.0 > Update dependencies to latest version >

[jira] [Created] (CALCITE-5792) Update dependencies to latest version

2023-06-21 Thread Parag Jain (Jira)
Parag Jain created CALCITE-5792: --- Summary: Update dependencies to latest version Key: CALCITE-5792 URL: https://issues.apache.org/jira/browse/CALCITE-5792 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5789: Labels: pull-request-available (was: ) > Query with two nested subqueries where the

[jira] [Assigned] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5789: -- Assignee: Ruben Q L > Query with two nested subqueries where the inner-most references the

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

2023-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Fix Version/s: 1.35.0 > Query with two nested subqueries where the inner-most references the >

[jira] [Commented] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-21 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735608#comment-17735608 ] jackylau commented on CALCITE-5772: --- hi [~julianhyde]  do you have time to help review? > Add

[jira] [Created] (CALCITE-5791) DDL commands ceased to work in 1.23-1.24 transition

2023-06-21 Thread Josef Spillner (Jira)
Josef Spillner created CALCITE-5791: --- Summary: DDL commands ceased to work in 1.23-1.24 transition Key: CALCITE-5791 URL: https://issues.apache.org/jira/browse/CALCITE-5791 Project: Calcite

[jira] [Commented] (CALCITE-5785) The :babel:fmppMain and :server:fmppMain tasks currently do not work with Gradle remote build caching

2023-06-21 Thread Akshay Dayal (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735549#comment-17735549 ] Akshay Dayal commented on CALCITE-5785: --- Hmmm I see the next snapshot build succeeded with an