[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

2023-08-25 Thread Guoliang Sun (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759190#comment-17759190 ] Guoliang Sun commented on CALCITE-5713: --- Thanks for the reply, having faced customer problems

[jira] [Commented] (CALCITE-5953) AggregateCaseToFilterRule may make inaccurate SUM transformation

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759156#comment-17759156 ] Julian Hyde commented on CALCITE-5953: -- [~libenchao], {quote}So returningĀ NULLĀ could give us more

[jira] [Commented] (CALCITE-5953) AggregateCaseToFilterRule may make inaccurate SUM transformation

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759155#comment-17759155 ] Julian Hyde commented on CALCITE-5953: -- The following cases seem safe (please check my reasoning!)

[jira] [Commented] (CALCITE-5950) Default column constraint is erroneously processed.

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759152#comment-17759152 ] Julian Hyde commented on CALCITE-5950: -- I've reviewed. When you've fixed the issues, please get

[jira] [Commented] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759147#comment-17759147 ] Julian Hyde commented on CALCITE-5948: -- Sounds good. > Explicit casting should be made if the

[jira] [Commented] (CALCITE-5923) Some test cases in `SqlOperatorTest` violates the test fixture's design principle

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759140#comment-17759140 ] Julian Hyde commented on CALCITE-5923: -- Good point, [~zabetak]. SqlOperatorTest makes it possible

[jira] [Commented] (CALCITE-5955) Non-aggregate window functions incorrectly contain window frame clause for BigQuery

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759139#comment-17759139 ] Julian Hyde commented on CALCITE-5955: -- As I've said before, {{PERCENTILE_CONT}} is an inverse

[jira] [Commented] (CALCITE-5713) SqlBasicCall's Deep Copy Logic Raises Rule Optimization Exception

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759137#comment-17759137 ] Julian Hyde commented on CALCITE-5713: -- I see that your PR does include a test case. I didn't read

[jira] [Commented] (CALCITE-5956) Support parsing non-standard collection types

2023-08-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759131#comment-17759131 ] Julian Hyde commented on CALCITE-5956: -- Yes it can support it in the core parser, but should it?

[jira] [Commented] (CALCITE-5836) Implement Rel2Sql for MERGE

2023-08-25 Thread Gregory Hart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759073#comment-17759073 ] Gregory Hart commented on CALCITE-5836: --- [~hongyuguo], I'd like to revisit this but it probably

[jira] [Commented] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759018#comment-17759018 ] Ran Tao commented on CALCITE-5948: -- this issue has changed to "Explicit casting should be made if the

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Summary: Explicit casting should be made if the type of an element in ARRAY not equals with the

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Summary: Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Component/s: core (was: avatica) > Explicit casting should be made if the type of

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Summary: Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY not equals with the derived component type

2023-08-25 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Summary: Explicit casting should be made if the type of an element in ARRAY not equals with the

[jira] [Updated] (CALCITE-5956) Support parsing non-standard collection types

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5956: Summary: Support parsing non-standard collection types (was: Support parsing non-standand

[jira] [Updated] (CALCITE-5956) Support parsing non-standand collection types

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5956: Description: Calcite support SQL standard collection types. For example: {code:sql} INTEGER

[jira] [Updated] (CALCITE-5956) Support parsing non-standand collection types

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5956: Summary: Support parsing non-standand collection types (was: Support parsing non-standand

[jira] [Updated] (CALCITE-5956) Support parsing non-standand collection types

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5956: Description: Calcite support SQL standard collection types, for example {code:sql} INTEGER

[jira] [Updated] (CALCITE-5956) Support parsing non-standand collection types

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5956: Description: Calcite support SQL standard collection types. For example: {code:sql} INTEGER

[jira] [Commented] (CALCITE-5949) RexExecutable correct handling of invalid constant expressions

2023-08-25 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759012#comment-17759012 ] Benchao Li commented on CALCITE-5949: - How about "RexExecutable should return unchanged original

[jira] [Updated] (CALCITE-5956) Support parsing non-standand collection type

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-5956: Description: Calcite support SQL standard collection types, for example {code:java} INTEGER

[jira] [Created] (CALCITE-5956) Support parsing non-standand collection type

2023-08-25 Thread hongyu guo (Jira)
hongyu guo created CALCITE-5956: --- Summary: Support parsing non-standand collection type Key: CALCITE-5956 URL: https://issues.apache.org/jira/browse/CALCITE-5956 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL

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

[jira] [Resolved] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL

2023-08-25 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5922. - Resolution: Fixed > The SQL generated for the POSITION function(with 3 input arguments) by the

[jira] [Commented] (CALCITE-5836) Implement Rel2Sql for MERGE

2023-08-25 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17758987#comment-17758987 ] hongyu guo commented on CALCITE-5836: - Hi [~freastro], I noticed that CALCITE-985 has been fixed.

[jira] [Resolved] (CALCITE-5615) Run SQL Logic Test suite using Calcite's HSQLDB JDBC adapter

2023-08-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-5615. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-5615) Run SQL Logic Test suite using Calcite's HSQLDB JDBC adapter

2023-08-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-5615: - Description: Add support for running [Sql Logic Test

[jira] [Updated] (CALCITE-5615) Run SQL Logic Test suite using Calcite's HSQLDB JDBC adapter

2023-08-25 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-5615: - Summary: Run SQL Logic Test suite using Calcite's HSQLDB JDBC adapter (was: