[jira] [Resolved] (CALCITE-6231) JDBC adapter generates "UNNEST" when it should generate "UNNEST ... WITH ORDINALITY"

[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo resolved CALCITE-6231. - Fix Version/s: 1.37.0 Resolution: Fixed > JDBC adapter generates "UNNEST" when it

[jira] [Comment Edited] (CALCITE-6231) JDBC adapter generates "UNNEST" when it should generate "UNNEST ... WITH ORDINALITY"

[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812562#comment-17812562 ] hongyu guo edited comment on CALCITE-6231 at 1/31/24 7:15 AM: -- Fixed in

[jira] [Commented] (CALCITE-6231) JDBC adapter generates "UNNEST" when it should generate "UNNEST ... WITH ORDINALITY"

[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812562#comment-17812562 ] hongyu guo commented on CALCITE-6231: - Fix in

[jira] [Updated] (CALCITE-6235) The MAP_CONTAINS_KEY function result does not necessarily correspond to the Spark result

[ https://issues.apache.org/jira/browse/CALCITE-6235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6235: Summary: The MAP_CONTAINS_KEY function result does not necessarily correspond to the Spark

[jira] [Commented] (CALCITE-6235) The MAP_CONTAINS_KEY function result does not necessarily correspond to the Spark result

[ https://issues.apache.org/jira/browse/CALCITE-6235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812524#comment-17812524 ] Caican Cai commented on CALCITE-6235: - ok， thank you > The MAP_CONTAINS_KEY function result does

[jira] [Resolved] (CALCITE-6208) JSON_VALUE 'RETURNING' syntax support for arrays with nullable elements

[ https://issues.apache.org/jira/browse/CALCITE-6208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6208. -- Fix Version/s: 1.37.0 Resolution: Fixed Resolved in

[jira] [Commented] (CALCITE-6206) Add library operator mapping for unparsing

[ https://issues.apache.org/jira/browse/CALCITE-6206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812427#comment-17812427 ] Tanner Clary commented on CALCITE-6206: --- I'm beginning to work on this, I was thinking maybe each

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812425#comment-17812425 ] Julian Hyde edited comment on CALCITE-6221 at 1/30/24 5:39 PM: --- Thank you

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812425#comment-17812425 ] Julian Hyde commented on CALCITE-6221: -- I agree that the subselect is necessary for the outer join

[jira] [Commented] (CALCITE-6235) MAP_CONTAINS_KEY function results correspond to Spark results

[ https://issues.apache.org/jira/browse/CALCITE-6235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812415#comment-17812415 ] Julian Hyde commented on CALCITE-6235: -- That expression doesn't have a valid type. You can't use a

[jira] [Created] (CALCITE-6235) MAP_CONTAINS_KEY function results correspond to Spark results

Caican Cai created CALCITE-6235: --- Summary: MAP_CONTAINS_KEY function results correspond to Spark results Key: CALCITE-6235 URL: https://issues.apache.org/jira/browse/CALCITE-6235 Project: Calcite

[jira] [Updated] (CALCITE-6234) Add Test on SqlOperatorTest for format_date function(enable Bigquery and pg)

[ https://issues.apache.org/jira/browse/CALCITE-6234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6234: Labels: pull-request-available (was: ) > Add Test on SqlOperatorTest for format_date

[jira] [Created] (CALCITE-6234) Add Test on SqlOperatorTest for format_date function(enable Bigquery and pg)

Caican Cai created CALCITE-6234: --- Summary: Add Test on SqlOperatorTest for format_date function(enable Bigquery and pg) Key: CALCITE-6234 URL: https://issues.apache.org/jira/browse/CALCITE-6234

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812318#comment-17812318 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:39 PM: - I

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812318#comment-17812318 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:38 PM: - I

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812318#comment-17812318 ] Ulrich Kramer commented on CALCITE-6221: I also thought about applying {{FilterIntoJoinRule}}

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:14 PM: - Now,

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:09 PM: - Now,

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:09 PM: - Now,

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:06 PM: - Now,

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer commented on CALCITE-6221: Now, I restricted the renaming of the fields in SQL to

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812256#comment-17812256 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 12:29 PM: -- I

[jira] [Created] (CALCITE-6233) Support parse of ISOWEEK on BigQuery library

Rodrigo Rueda created CALCITE-6233: -- Summary: Support parse of ISOWEEK on BigQuery library Key: CALCITE-6233 URL: https://issues.apache.org/jira/browse/CALCITE-6233 Project: Calcite Issue

[jira] [Commented] (CALCITE-6231) JDBC adapter generates "UNNEST" when it should generate "UNNEST ... WITH ORDINALITY"

[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812268#comment-17812268 ] EveyWu commented on CALCITE-6231: -- [~julianhyde] thanks for the modification，I have changed the pr

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812256#comment-17812256 ] Ulrich Kramer commented on CALCITE-6221: I will try to keep the changes as small as possible.

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812256#comment-17812256 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 10:35 AM: -- I