[jira] [Updated] (CALCITE-6306) JDBC adapter should not generate FILTER (WHERE) in MySQL and StarRocks dialect

2024-03-07 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6306: Summary: JDBC adapter should not generate FILTER (WHERE) in MySQL and StarRocks dialect (was:

[jira] [Updated] (CALCITE-6306) FILTER clauses for aggregate functions are not supported in MySQL, MariaDB and StarRocks

2024-03-07 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6306: Summary: FILTER clauses for aggregate functions are not supported in MySQL, MariaDB and

[jira] [Updated] (CALCITE-6306) FILTER clauses for aggregate functions are not supported in MySQL, MariaDB and Starrocks

2024-03-07 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6306: Description: {code:sql} mysql> select sum(x) filter (where x = 1) from t; ERROR 1064 (42000):

[jira] [Updated] (CALCITE-6306) FILTER clauses for aggregate functions are not supported in MySQL, MariaDB and Starrocks

2024-03-07 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6306: Description: {code:sql} mysql> select sum(x) filter (where x = 1) from t; ERROR 1064 (42000):

[jira] [Commented] (CALCITE-6308) Add PostgreSQL functions up to PostgreSQL v14

2024-03-07 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824590#comment-17824590 ] James Duong commented on CALCITE-6308: -- Thanks [~tanclary] . I've added you to the RANDOM PR:

[jira] [Updated] (CALCITE-6314) Support PostgreSQL RANDOM

2024-03-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6314: Labels: pull-request-available (was: ) > Support PostgreSQL RANDOM >

[jira] [Assigned] (CALCITE-5607) Datetime MINUS throws ArrayIndexOutOfBounds error when serializing toRex

2024-03-07 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oliver Lee reassigned CALCITE-5607: --- Assignee: Oliver Lee > Datetime MINUS throws ArrayIndexOutOfBounds error when serializing

[jira] [Comment Edited] (CALCITE-5607) Datetime MINUS throws ArrayIndexOutOfBounds error when serializing toRex

2024-03-07 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824580#comment-17824580 ] Oliver Lee edited comment on CALCITE-5607 at 3/8/24 12:35 AM: -- Yeah that

[jira] [Updated] (CALCITE-6316) Update Javadoc for CALCITE-5607

2024-03-07 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6316: Labels: pull-request-available (was: ) > Update Javadoc for CALCITE-5607 >

[jira] [Created] (CALCITE-6316) Update Javadoc for CALCITE-5607

2024-03-07 Thread Oliver Lee (Jira)
Oliver Lee created CALCITE-6316: --- Summary: Update Javadoc for CALCITE-5607 Key: CALCITE-6316 URL: https://issues.apache.org/jira/browse/CALCITE-6316 Project: Calcite Issue Type: Task

[jira] [Commented] (CALCITE-5607) Datetime MINUS throws ArrayIndexOutOfBounds error when serializing toRex

2024-03-07 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824580#comment-17824580 ] Oliver Lee commented on CALCITE-5607: - Yeah that is fair.   I'll just log a new case to update

[jira] [Created] (CALCITE-6315) Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6315: Summary: Support PostgreSQL TO_CHAR, TO_DATE, TO_TIMESTAMP Key: CALCITE-6315 URL: https://issues.apache.org/jira/browse/CALCITE-6315 Project: Calcite Issue

[jira] [Created] (CALCITE-6314) Support PostgreSQL RANDOM

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6314: Summary: Support PostgreSQL RANDOM Key: CALCITE-6314 URL: https://issues.apache.org/jira/browse/CALCITE-6314 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6313) Support PostgreSQL POW

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6313: Summary: Support PostgreSQL POW Key: CALCITE-6313 URL: https://issues.apache.org/jira/browse/CALCITE-6313 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6312) Support PostgreSQL LOG

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6312: Summary: Support PostgreSQL LOG Key: CALCITE-6312 URL: https://issues.apache.org/jira/browse/CALCITE-6312 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6311) Support PostgreSQL DATE_PART

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6311: Summary: Support PostgreSQL DATE_PART Key: CALCITE-6311 URL: https://issues.apache.org/jira/browse/CALCITE-6311 Project: Calcite Issue Type: Sub-task

[jira] [Updated] (CALCITE-6309) Support PostgreSQL REGEXP_LIKE

2024-03-07 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6309: - Description: * The Spark version of this is being implemented in CALCITE-6278 * The

[jira] [Created] (CALCITE-6310) Support PostgreSQL REGEXP_REPLACE

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6310: Summary: Support PostgreSQL REGEXP_REPLACE Key: CALCITE-6310 URL: https://issues.apache.org/jira/browse/CALCITE-6310 Project: Calcite Issue Type: Sub-task

[jira] [Created] (CALCITE-6309) Support PostgreSQL REGEXP_LIKE

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6309: Summary: Support PostgreSQL REGEXP_LIKE Key: CALCITE-6309 URL: https://issues.apache.org/jira/browse/CALCITE-6309 Project: Calcite Issue Type: Sub-task

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

2024-03-07 Thread Bertil Chapuis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824563#comment-17824563 ] Bertil Chapuis commented on CALCITE-6239: - [~julianhyde] Thanks a lot, I wouldn't have been

[jira] [Commented] (CALCITE-6308) Add PostgreSQL functions up to PostgreSQL v14

2024-03-07 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824543#comment-17824543 ] Tanner Clary commented on CALCITE-6308: --- seems like a good initiative, tag me on reviews for

[jira] [Created] (CALCITE-6308) Add PostgreSQL functions up to PostgreSQL v14

2024-03-07 Thread James Duong (Jira)
James Duong created CALCITE-6308: Summary: Add PostgreSQL functions up to PostgreSQL v14 Key: CALCITE-6308 URL: https://issues.apache.org/jira/browse/CALCITE-6308 Project: Calcite Issue

[jira] [Created] (CALCITE-6307) Sonar analysis in CI fails with 'java.lang.OutOfMemoryError: Java heap space'

2024-03-07 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-6307: - Summary: Sonar analysis in CI fails with 'java.lang.OutOfMemoryError: Java heap space' Key: CALCITE-6307 URL: https://issues.apache.org/jira/browse/CALCITE-6307

[jira] [Updated] (CALCITE-6305) Increase coverage of unit tests for the Arrow adapter

2024-03-07 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-6305: -- Summary: Increase coverage of unit tests for the Arrow adapter (was:

[jira] [Assigned] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

2024-03-07 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reassigned CALCITE-6265: - Assignee: Tim Nieradzik (was: Alessandro Solimando) > Type coercion

[jira] [Commented] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824456#comment-17824456 ] Julian Hyde commented on CALCITE-6278: -- Can you expand on “Since Spark 2.0, string literals

[jira] [Commented] (CALCITE-6305) Increase coverage of unit tests for arrow adapter

2024-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824453#comment-17824453 ] Julian Hyde commented on CALCITE-6305: -- Should be “Arrow” not “arrow”. Sorry to be pedantic, but

[jira] [Commented] (CALCITE-6306) FILTER clauses for aggregate functions are not supported in MySQL, MariaDB and Starrocks

2024-03-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824451#comment-17824451 ] Julian Hyde commented on CALCITE-6306: -- Can you change the subject so it’s clear which calcite

[jira] [Updated] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

2024-03-07 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Nieradzik updated CALCITE-6265: --- Description: Given a column of type {{{}INT{}}}. When providing a {{short}} value as a

[jira] [Commented] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

2024-03-07 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824374#comment-17824374 ] Tim Nieradzik commented on CALCITE-6265: [~asolimando] The title was indeed confusing. I made

[jira] [Updated] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

2024-03-07 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Nieradzik updated CALCITE-6265: --- Description: Given a column of type {{{}INT{}}}. When providing a {{short}} value as a

[jira] [Updated] (CALCITE-6265) Type coercion is failing for numeric values in prepared statements

2024-03-07 Thread Tim Nieradzik (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tim Nieradzik updated CALCITE-6265: --- Summary: Type coercion is failing for numeric values in prepared statements (was: Cannot

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

2024-03-07 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao resolved CALCITE-5893. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2024-03-07 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824357#comment-17824357 ] hongyu guo commented on CALCITE-2040: - [~zabetak] I have addad 5 co-authors, based on the PR2133

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2024-03-07 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824299#comment-17824299 ] Stamatis Zampetakis commented on CALCITE-2040: -- Many people contributed to this work so