[jira] [Comment Edited] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817844#comment-17817844 ] Sergey Nuyanzin edited comment on CALCITE-6266 at 2/16/24 5:23 AM: ---

[jira] [Comment Edited] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817844#comment-17817844 ] Sergey Nuyanzin edited comment on CALCITE-6266 at 2/16/24 4:57 AM: ---

[jira] [Commented] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817844#comment-17817844 ] Sergey Nuyanzin commented on CALCITE-6266: -- it seems I found the reason in a new version this

[jira] [Updated] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6266: Labels: pull-request-available (was: ) > SqlValidatorException with LATERAL TABLE and

[jira] [Commented] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817818#comment-17817818 ] Sergey Nuyanzin commented on CALCITE-6266: -- it seems it fails for both {quote} If you change

[jira] [Commented] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817803#comment-17817803 ] Julian Hyde commented on CALCITE-6266: -- That makes sense. I had the same hypothesis. But if the

[jira] [Commented] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Jeyhun Karimov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817802#comment-17817802 ] Jeyhun Karimov commented on CALCITE-6266: - Hi [~julianhyde] IMO presedence might not be the

[jira] [Commented] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817764#comment-17817764 ] Julian Hyde commented on CALCITE-6266: -- It's quite possible that the new behavior is correct, and

[jira] [Commented] (CALCITE-6259) The implementation of the Log library operator does not match the actual dialect behavior.

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817763#comment-17817763 ] Julian Hyde commented on CALCITE-6259: -- As I said above, the behavior of LOGx functions should be

[jira] [Commented] (CALCITE-6263) Discuss the coupling of Calcite with JTS

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817762#comment-17817762 ] Julian Hyde commented on CALCITE-6263: -- I used string (WKT) as a simple example; binary (WKB)

[jira] [Updated] (CALCITE-6239) Add a postgis dialect that supports ST functions

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6239: - Component/s: spatial > Add a postgis dialect that supports ST functions >

[jira] [Updated] (CALCITE-6239) Add a PostGIS dialect that supports ST_ functions

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6239: - Summary: Add a PostGIS dialect that supports ST_ functions (was: Add a postgis dialect that

[jira] [Commented] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817759#comment-17817759 ] Julian Hyde commented on CALCITE-6265: -- Sure, it shows up in Calcite, but it's due to Avatica not

[jira] [Commented] (CALCITE-6265) Cannot provide different numeric type as placeholder

2024-02-15 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817747#comment-17817747 ] Alessandro Solimando commented on CALCITE-6265: --- In principle I agree, but it seems that

[jira] [Commented] (CALCITE-6252) BigQuery FORMAT_DATE uses the wrong calendar for Julian dates

2024-02-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817721#comment-17817721 ] Julian Hyde commented on CALCITE-6252: -- It's OK to change the summary, but it might be OK to keep

[jira] [Comment Edited] (CALCITE-6252) BigQuery FORMAT_DATE uses the wrong calendar for Julian dates

2024-02-15 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817719#comment-17817719 ] Caican Cai edited comment on CALCITE-6252 at 2/15/24 3:47 PM: -- [~mbudiu]

[jira] [Commented] (CALCITE-6252) BigQuery FORMAT_DATE uses the wrong calendar for Julian dates

2024-02-15 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817719#comment-17817719 ] Caican Cai commented on CALCITE-6252: - [~mbudiu] Hello, I noticed that the to_char function of

[jira] [Comment Edited] (CALCITE-6267) Add subquery test and cte test in ToLogicalConverterTest

2024-02-15 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817709#comment-17817709 ] Caican Cai edited comment on CALCITE-6267 at 2/15/24 3:29 PM: -- I have a

[jira] [Commented] (CALCITE-6267) Add subquery test and cte test in ToLogicalConverterTest

2024-02-15 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817709#comment-17817709 ] Caican Cai commented on CALCITE-6267: - I have a question, based on what considerations are the

[jira] [Updated] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Jeyhun Karimov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeyhun Karimov updated CALCITE-6266: Description: I have the following test in SqlValidatorTest.java {code:java} @Test void

[jira] [Updated] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Jeyhun Karimov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeyhun Karimov updated CALCITE-6266: Affects Version/s: 1.31.0 > SqlValidatorException with LATERAL TABLE and JOIN >

[jira] [Created] (CALCITE-6267) Add subquery test and cte test in ToLogicalConverterTest

2024-02-15 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6267: --- Summary: Add subquery test and cte test in ToLogicalConverterTest Key: CALCITE-6267 URL: https://issues.apache.org/jira/browse/CALCITE-6267 Project: Calcite

[jira] [Commented] (CALCITE-6261) RelBuilder.aggregate() field pruning does not use permuted field indices when used with force project and duplicate agg calls

2024-02-15 Thread Petr Masopust (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817695#comment-17817695 ] Petr Masopust commented on CALCITE-6261: [~zrlpar] your test looks good, thank you. >

[jira] [Commented] (CALCITE-6263) Discuss the coupling of Calcite with JTS

2024-02-15 Thread Bertil Chapuis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817689#comment-17817689 ] Bertil Chapuis commented on CALCITE-6263: - Quick question, what would you think about

[jira] [Comment Edited] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817664#comment-17817664 ] Sergey Nuyanzin edited comment on CALCITE-6266 at 2/15/24 12:50 PM:

[jira] [Commented] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817664#comment-17817664 ] Sergey Nuyanzin commented on CALCITE-6266: -- bisect shows it comes with CALCITE-35 >

[jira] [Commented] (CALCITE-6259) The implementation of the Log library operator does not match the actual dialect behavior.

2024-02-15 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817647#comment-17817647 ] Caican Cai commented on CALCITE-6259: - [~julianhyde] [~tanclary]  Hello, I have a question, the

[jira] [Comment Edited] (CALCITE-6259) The implementation of the Log library operator does not match the actual dialect behavior.

2024-02-15 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817647#comment-17817647 ] Caican Cai edited comment on CALCITE-6259 at 2/15/24 12:09 PM: ---

[jira] [Updated] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Jeyhun Karimov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeyhun Karimov updated CALCITE-6266: Affects Version/s: 1.35.0 1.34.0 1.33.0

[jira] [Created] (CALCITE-6266) SqlValidatorException with LATERAL TABLE and JOIN

2024-02-15 Thread Jeyhun Karimov (Jira)
Jeyhun Karimov created CALCITE-6266: --- Summary: SqlValidatorException with LATERAL TABLE and JOIN Key: CALCITE-6266 URL: https://issues.apache.org/jira/browse/CALCITE-6266 Project: Calcite

[jira] [Commented] (CALCITE-6263) Discuss the coupling of Calcite with JTS

2024-02-15 Thread Bertil Chapuis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817623#comment-17817623 ] Bertil Chapuis commented on CALCITE-6263: - Thank you very much for these clarifications. I

[jira] [Commented] (CALCITE-6261) RelBuilder.aggregate() field pruning does not use permuted field indices when used with force project and duplicate agg calls

2024-02-15 Thread Niels Pardon (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17817618#comment-17817618 ] Niels Pardon commented on CALCITE-6261: --- I tried recreating both scenarios in SQL and I can't