[jira] [Updated] (CALCITE-5893) Wrong NULL literal behavior of ARRAY_CONTAINS/ARRAY_EXCEPT/ARRAY_INTERSECT In Spark Library

[ https://issues.apache.org/jira/browse/CALCITE-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5893: - Description: The following are the implementations of some array functions in calcite({*}Spark

[jira] [Updated] (CALCITE-5893) Wrong NULL literal behavior of ARRAY_CONTAINS/ARRAY_EXCEPT/ARRAY_INTERSECT In Spark Library

[ https://issues.apache.org/jira/browse/CALCITE-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5893: - Description: The following are the implementations of some array functions in calcite({*}Spark

[jira] [Updated] (CALCITE-5893) Wrong NULL literal behavior of ARRAY_CONTAINS/ARRAY_EXCEPT/ARRAY_INTERSECT In Spark Library

[ https://issues.apache.org/jira/browse/CALCITE-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5893: - Description: The following are the implementations of some array functions in calcite({*}Spark

[jira] [Created] (CALCITE-5893) Wrong NULL literal behavior of ARRAY_CONTAINS/ARRAY_EXCEPT/ARRAY_INTERSECT In Spark Library

Ran Tao created CALCITE-5893: Summary: Wrong NULL literal behavior of ARRAY_CONTAINS/ARRAY_EXCEPT/ARRAY_INTERSECT In Spark Library Key: CALCITE-5893 URL: https://issues.apache.org/jira/browse/CALCITE-5893

[jira] [Commented] (CALCITE-5830) Add ARRAY_INSERT function(enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750540#comment-17750540 ] xiong duan commented on CALCITE-5830: - Hi, [~taoran]  I will review and welcome other developers to

[jira] [Commented] (CALCITE-5830) Add ARRAY_INSERT function(enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750525#comment-17750525 ] Ran Tao commented on CALCITE-5830: -- anyone can help me to review this? > Add ARRAY_INSERT

[jira] [Updated] (CALCITE-5837) RexUtil#pullFactors output's order should be deterministic even when the RexNode kind is OR

[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5837: -- Issue Type: Improvement (was: Bug) > RexUtil#pullFactors output's order should be deterministic

[jira] [Commented] (CALCITE-5888) Assertion error in aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750519#comment-17750519 ] xiong duan commented on CALCITE-5888: - [~pmsgd] Hi, I can't get your point. Can we have a SQL to

[jira] [Commented] (CALCITE-5875) Remove unnecessary NULL checks in Redis adapter

[ https://issues.apache.org/jira/browse/CALCITE-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750513#comment-17750513 ] xiong duan commented on CALCITE-5875: - Fixed in

[jira] [Resolved] (CALCITE-5875) Remove unnecessary NULL checks in Redis adapter

[ https://issues.apache.org/jira/browse/CALCITE-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-5875. - Resolution: Fixed > Remove unnecessary NULL checks in Redis adapter >

[jira] [Updated] (CALCITE-5875) Remove unnecessary NULL checks in Redis adapter

[ https://issues.apache.org/jira/browse/CALCITE-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-5875: Summary: Remove unnecessary NULL checks in Redis adapter (was: Remove unnecessary NULL checks

[jira] [Assigned] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

[ https://issues.apache.org/jira/browse/CALCITE-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Riasanovsky reassigned CALCITE-5892: - Assignee: Nick Riasanovsky > SnowflakeSqlDialect doesn't provide custom

[jira] [Updated] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

[ https://issues.apache.org/jira/browse/CALCITE-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Riasanovsky updated CALCITE-5892: -- Description: Snowflake has Interval Literal syntax that is different from other SQL

[jira] [Updated] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

[ https://issues.apache.org/jira/browse/CALCITE-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Riasanovsky updated CALCITE-5892: -- Description: Snowflake has Interval Literal syntax that is different from other SQL

[jira] [Updated] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

[ https://issues.apache.org/jira/browse/CALCITE-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Riasanovsky updated CALCITE-5892: -- Affects Version/s: 1.35.0 > SnowflakeSqlDialect doesn't provide custom

[jira] [Created] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

Nick Riasanovsky created CALCITE-5892: - Summary: SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support Key: CALCITE-5892 URL: https://issues.apache.org/jira/browse/CALCITE-5892

[jira] [Updated] (CALCITE-5892) SnowflakeSqlDialect doesn't provide custom unparseSqlIntervalLiteral support

[ https://issues.apache.org/jira/browse/CALCITE-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Riasanovsky updated CALCITE-5892: -- Priority: Minor (was: Major) > SnowflakeSqlDialect doesn't provide custom

[jira] [Updated] (CALCITE-5884) Type Inference rule for ARRAY_TO_STRING is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-5884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5884: Labels: pull-request-available (was: ) > Type Inference rule for ARRAY_TO_STRING is

[jira] [Created] (CALCITE-5891) Create a test fixture that would apply PROJECT_REDUCE_EXPRESSIONS to all tests in SqlOperatorTest

Mihai Budiu created CALCITE-5891: Summary: Create a test fixture that would apply PROJECT_REDUCE_EXPRESSIONS to all tests in SqlOperatorTest Key: CALCITE-5891 URL:

[jira] [Resolved] (CALCITE-5735) Add SAFE_MULTIPLY function (enabled for BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-5735. --- Fix Version/s: 1.36.0 Resolution: Fixed Merged via

[jira] [Resolved] (CALCITE-5820) Add PARSE_URL function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-5820. --- Fix Version/s: 1.36.0 Resolution: Fixed Merged via

[jira] [Resolved] (CALCITE-5859) Compile-time evaluation of LEFT(NULL, n) should not throw RuntimeException

[ https://issues.apache.org/jira/browse/CALCITE-5859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5859. --- Resolution: Fixed Merged via

[jira] [Assigned] (CALCITE-5859) Compile-time evaluation of LEFT(NULL, n) should not throw RuntimeException

[ https://issues.apache.org/jira/browse/CALCITE-5859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-5859: - Assignee: Mihai Budiu > Compile-time evaluation of LEFT(NULL, n)

[jira] [Resolved] (CALCITE-5837) RexUtil#pullFactors output's order should be deterministic even when the RexNode kind is OR

[ https://issues.apache.org/jira/browse/CALCITE-5837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-5837. --- Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5875) Remove unnecessary NULL checks in Redis adapter"

[ https://issues.apache.org/jira/browse/CALCITE-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750384#comment-17750384 ] Ran Tao commented on CALCITE-5875: -- [~nobigo] thanks. changed it. > Remove unnecessary NULL checks in

[jira] [Updated] (CALCITE-5875) Remove unnecessary NULL checks in Redis adapter"

[ https://issues.apache.org/jira/browse/CALCITE-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5875: - Summary: Remove unnecessary NULL checks in Redis adapter" (was: Remove some unnecessary null checks

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750373#comment-17750373 ] Julian Hyde commented on CALCITE-5889: -- Can you give a SQL query (involving say Emp and Dept) that

[jira] [Updated] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5889: -- Summary: Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE (was: Add the RelRule

[jira] [Updated] (CALCITE-5889) Add the RelRule that converts Minus to into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5889: -- Description: There are many projects that implement optimizers based on Calcite,our optimizer is

[jira] [Updated] (CALCITE-5890) Handle non-JKS truststores in Avatica client

[ https://issues.apache.org/jira/browse/CALCITE-5890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth updated CALCITE-5890: - Summary: Handle non-JKS truststores in Avatica client (was: Handle non-JKS keystores in

[jira] [Commented] (CALCITE-5890) Handle non-JKS keystores in client

[ https://issues.apache.org/jira/browse/CALCITE-5890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750293#comment-17750293 ] Istvan Toth commented on CALCITE-5890: -- FYI [~richardantal]  > Handle non-JKS keystores in client

[jira] [Updated] (CALCITE-5889) Add the RelRule that converts Minus to into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5889: -- Description: There are many projects that implement optimizers based on Calcite,our optimizer is

[jira] [Created] (CALCITE-5890) Handle non-JKS keystores in client

Istvan Toth created CALCITE-5890: Summary: Handle non-JKS keystores in client Key: CALCITE-5890 URL: https://issues.apache.org/jira/browse/CALCITE-5890 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-5889) Add the RelRule that converts Minus to into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5889: -- Description: There are many projects that implement optimizers based on Calcite,our optimizer is

[jira] [Updated] (CALCITE-5889) Add the RelRule that converts Minus to into UNION ALL..GROUP BY...WHERE

[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5889: -- Description: There are many projects that implement optimizers based on Calcite,our optimizer is

[jira] [Created] (CALCITE-5889) Add the RelRule that converts Minus to into UNION ALL..GROUP BY...WHERE

LakeShen created CALCITE-5889: - Summary: Add the RelRule that converts Minus to into UNION ALL..GROUP BY...WHERE Key: CALCITE-5889 URL: https://issues.apache.org/jira/browse/CALCITE-5889 Project: Calcite

[jira] [Updated] (CALCITE-5870) Allow literals like DECIMAL '12.3' (consistent with Postgres)

[ https://issues.apache.org/jira/browse/CALCITE-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5870: -- Issue Type: New Feature (was: Improvement) > Allow literals like DECIMAL '12.3' (consistent with

[jira] [Created] (CALCITE-5888) Assertion error in aggregate

Petr Masopust created CALCITE-5888: -- Summary: Assertion error in aggregate Key: CALCITE-5888 URL: https://issues.apache.org/jira/browse/CALCITE-5888 Project: Calcite Issue Type: Bug

[jira] [Closed] (CALCITE-5886) Task :spark:testClasses unstable due to ConnectException

[ https://issues.apache.org/jira/browse/CALCITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen closed CALCITE-5886. - Resolution: Not A Problem > Task :spark:testClasses unstable due to ConnectException >

[jira] [Commented] (CALCITE-5886) Task :spark:testClasses unstable due to ConnectException

[ https://issues.apache.org/jira/browse/CALCITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750277#comment-17750277 ] LakeShen commented on CALCITE-5886: --- Hi [~taoran],thank you for your reply,I got your point. > Task

[jira] [Commented] (CALCITE-5875) Remove some unnecessary null checks for redis adapter

[ https://issues.apache.org/jira/browse/CALCITE-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750274#comment-17750274 ] xiong duan commented on CALCITE-5875: - [~taoran], How about we change the issue summary to "Remove

[jira] [Commented] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750269#comment-17750269 ] xiong duan commented on CALCITE-5851: - Fixed in 

[jira] [Resolved] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-5851. - Fix Version/s: 1.36.0 Resolution: Fixed > Add LEVENSHTEIN function (enabled in Hive and

[jira] [Created] (CALCITE-5887) Trim function can’t work well with SqlDelegatingConformance

Guoliang Sun created CALCITE-5887: - Summary: Trim function can’t work well with SqlDelegatingConformance Key: CALCITE-5887 URL: https://issues.apache.org/jira/browse/CALCITE-5887 Project: Calcite

[jira] [Resolved] (CALCITE-5877) AssertionError during MOD operation if result scale is greater than maximum numeric scale

[ https://issues.apache.org/jira/browse/CALCITE-5877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5877. Resolution: Fixed Done via

[jira] [Comment Edited] (CALCITE-5886) Task :spark:testClasses unstable due to ConnectException

[ https://issues.apache.org/jira/browse/CALCITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750151#comment-17750151 ] Ran Tao edited comment on CALCITE-5886 at 8/2/23 7:14 AM: -- [~shenlang] hi,

[jira] [Comment Edited] (CALCITE-5886) Task :spark:testClasses unstable due to ConnectException

[ https://issues.apache.org/jira/browse/CALCITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750151#comment-17750151 ] Ran Tao edited comment on CALCITE-5886 at 8/2/23 7:13 AM: -- [~shenlang] hi,

[jira] [Commented] (CALCITE-5886) Task :spark:testClasses unstable due to ConnectException

[ https://issues.apache.org/jira/browse/CALCITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750151#comment-17750151 ] Ran Tao commented on CALCITE-5886: -- [~shenlang] hi, Shen. Some occasional CI failures are unavoidable.