[jira] [Commented] (CALCITE-6209) Long queries are failing with "java.net.SocketTimeoutException: Read timed out" after 3 minutes

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827756#comment-17827756 ] Julian Hyde commented on CALCITE-6209: -- Thank you for adding the link. And, thanks for the fix

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827755#comment-17827755 ] Julian Hyde commented on CALCITE-6314: -- Looks like you figured it out. By the way, when we're

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827753#comment-17827753 ] Julian Hyde commented on CALCITE-2980: -- A good test is really valuable. I wouldn't disable

[jira] [Commented] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-03-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827752#comment-17827752 ] Julian Hyde commented on CALCITE-6332: -- There are two algorithms to rewrite distinct aggregates

[jira] [Updated] (CALCITE-6330) Print the average row size when explaining an operator at the ALL_ATTRIBUTES level

2024-03-16 Thread mengdou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] mengdou updated CALCITE-6330: - Summary: Print the average row size when explaining an operator at the ALL_ATTRIBUTES level

[jira] [Updated] (CALCITE-6330) Print the average row size when explaining an operator

2024-03-16 Thread mengdou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] mengdou updated CALCITE-6330: - Summary: Print the average row size when explaining an operator (was: Print the average row size when

[jira] [Commented] (CALCITE-6333) Queries with distinct aggregations with filter throw NPE when planned using joins

2024-03-15 Thread Abhishek Agarwal (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827643#comment-17827643 ] Abhishek Agarwal commented on CALCITE-6333: --- [~julianhyde] - The plan looks right to me. I

[jira] [Commented] (CALCITE-6333) Queries with distinct aggregations with filter throw NPE when planned using joins

2024-03-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827570#comment-17827570 ] Julian Hyde commented on CALCITE-6333: -- Your PR seems to make the NPE go away by removing

[jira] [Updated] (CALCITE-6333) Queries with distinct aggregations with filter throw NPE when planned using joins

2024-03-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6333: Labels: pull-request-available (was: ) > Queries with distinct aggregations with fil

[jira] [Created] (CALCITE-6333) Queries with distinct aggregations with filter throw NPE when planned using joins

2024-03-15 Thread Abhishek Agarwal (Jira)
Abhishek Agarwal created CALCITE-6333: - Summary: Queries with distinct aggregations with filter throw NPE when planned using joins Key: CALCITE-6333 URL: https://issues.apache.org/jira/browse/CALCITE-6333

[jira] [Updated] (CALCITE-6319) Add negative test to POW and POWER functions

2024-03-14 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6319: Fix Version/s: (was: 1.37.0) > Add negative test to POW and POWER functi

[jira] [Created] (CALCITE-6332) Optimization CoreRules.AGGREGATE_EXPAND_DISTINCT_AGGREGATES_TO_JOIN produces incorrect results for aggregates with groupSets

2024-03-14 Thread Mihai Budiu (Jira)
://issues.apache.org/jira/browse/CALCITE-6332 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.36.0 Reporter: Mihai Budiu The optimization rule does not seem to consider the groupSets at all. The following two queries produce the same

[jira] [Resolved] (CALCITE-6138) Parser does not accept TIMESTAMP WITH TIME ZONE as a data type

2024-03-14 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6138. -- Resolution: Fixed > Parser does not accept TIMESTAMP WITH TIME ZONE as a data t

[jira] [Commented] (CALCITE-6319) Add negative test to POW and POWER functions

2024-03-14 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827317#comment-17827317 ] hongyu guo commented on CALCITE-6319: - Hi [~caicancai]. Are you still working on this jira

[jira] [Commented] (CALCITE-6138) Parser does not accept TIMESTAMP WITH TIME ZONE as a data type

2024-03-14 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827316#comment-17827316 ] hongyu guo commented on CALCITE-6138: - Has this bug been fixed? we should mark this ticket

[jira] [Updated] (CALCITE-6310) Add REGEXP_LIKE function (enabled in PostgreSQL library)

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong updated CALCITE-6310: - Summary: Add REGEXP_LIKE function (enabled in PostgreSQL library) (was: Support PostgreSQL

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

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6310: Assignee: James Duong > Support PostgreSQL REGEXP_REPL

[jira] [Assigned] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6309: Assignee: James Duong > Add REGEXP_LIKE function (enabled in MySQL, Oracle, Postgre

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2024-03-14 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827231#comment-17827231 ] Tanner Clary commented on CALCITE-2980: --- [~jerin_john]I see no problem with this. In my mind

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2024-03-14 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827222#comment-17827222 ] Jerin John commented on CALCITE-2980: - Team, I wanted to discuss about the timeline to enable

[jira] [Comment Edited] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827197#comment-17827197 ] James Duong edited comment on CALCITE-6314 at 3/14/24 6:15 PM: --- I worked

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827197#comment-17827197 ] James Duong commented on CALCITE-6314: -- I worked with ASF infra to get Contributor permissions

[jira] [Assigned] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong reassigned CALCITE-6314: Assignee: James Duong (was: Tanner Clary) > Add RANDOM function (enabled in Postg

[jira] [Comment Edited] (CALCITE-6328) The BigQuery functions SAFE_* do not match the BigQuery specification

2024-03-14 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827192#comment-17827192 ] Mihai Budiu edited comment on CALCITE-6328 at 3/14/24 5:49 PM

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827186#comment-17827186 ] Mihai Budiu commented on CALCITE-6314: -- I can't assign James either, it says that the user name

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827174#comment-17827174 ] Tanner Clary commented on CALCITE-6314: --- [~julianhyde] do you know how to switch? I want to make

[jira] [Commented] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827173#comment-17827173 ] James Duong commented on CALCITE-6314: -- I wonder if this is an issue with my account

[jira] [Commented] (CALCITE-6330) Print the average row size when when explaining an operator

2024-03-14 Thread mengdou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827167#comment-17827167 ] mengdou commented on CALCITE-6330: -- [~zabetak]  Thanks for your explanation. I agree with you about

[jira] [Resolved] (CALCITE-6314) Add RANDOM function (enabled in Postgres library)

2024-03-14 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-6314. --- Fix Version/s: 1.37.0 Assignee: Tanner Clary Resolution: Fixed Merged via

[jira] [Commented] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827126#comment-17827126 ] Stamatis Zampetakis commented on CALCITE-6331: -- I don't remember the motivation behind

[jira] [Resolved] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Calvin Kirs resolved CALCITE-6331. -- Resolution: Invalid > The third-party source code file doesn't have a License f

[jira] [Commented] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827109#comment-17827109 ] Calvin Kirs commented on CALCITE-6331: -- It looks like we used a script to organize the license

[jira] [Commented] (CALCITE-6330) Print the average row size when when explaining an operator

2024-03-14 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827073#comment-17827073 ] Stamatis Zampetakis commented on CALCITE-6330: -- Based on the SqlExplainLevel specification

[jira] [Commented] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827068#comment-17827068 ] Stamatis Zampetakis commented on CALCITE-6331: -- The licenses can be found here: [https

[jira] [Updated] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Calvin Kirs updated CALCITE-6331: - Description: [https://github.com/apache/calcite/blob/main/LICENSE#L184-L196] We reference

[jira] [Updated] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Calvin Kirs updated CALCITE-6331: - Description: [https://github.com/apache/calcite/blob/main/LICENSE#L184-L196] We reference

[jira] [Updated] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Calvin Kirs updated CALCITE-6331: - Description: [https://github.com/apache/calcite/blob/main/LICENSE#L184-L196] We reference

[jira] [Updated] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Calvin Kirs updated CALCITE-6331: - Description: [https://github.com/apache/calcite/blob/main/LICENSE#L184-L196] We reference

[jira] [Updated] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6331: Labels: pull-request-available (was: ) > The third-party source code file doesn't h

[jira] [Created] (CALCITE-6331) The third-party source code file doesn't have a License file.

2024-03-14 Thread Calvin Kirs (Jira)
Calvin Kirs created CALCITE-6331: Summary: The third-party source code file doesn't have a License file. Key: CALCITE-6331 URL: https://issues.apache.org/jira/browse/CALCITE-6331 Project: Calcite

[jira] [Commented] (CALCITE-6328) The BigQuery functions SAFE_* do not match the BigQuery specification

2024-03-13 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17826940#comment-17826940 ] Tanner Clary commented on CALCITE-6328: --- Sounds good (y) > The BigQuery functions SAFE_*

[jira] [Created] (CALCITE-6330) Print the average row size when when explaining an operator

2024-03-13 Thread mengdou (Jira)
mengdou created CALCITE-6330: Summary: Print the average row size when when explaining an operator Key: CALCITE-6330 URL: https://issues.apache.org/jira/browse/CALCITE-6330 Project: Calcite

[jira] [Updated] (CALCITE-6329) Use weighted-average calculation for the column sizes in Union operator

2024-03-13 Thread mengdou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] mengdou updated CALCITE-6329: - Summary: Use weighted-average calculation for the column sizes in Union operator (was: Use weighted

[jira] [Created] (CALCITE-6329) Use weighted-average calculation for the columns in Union operator

2024-03-13 Thread mengdou (Jira)
mengdou created CALCITE-6329: Summary: Use weighted-average calculation for the columns in Union operator Key: CALCITE-6329 URL: https://issues.apache.org/jira/browse/CALCITE-6329 Project: Calcite

[jira] [Commented] (CALCITE-6328) The BigQuery functions SAFE_* do not match the BigQuery specification

2024-03-13 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17826906#comment-17826906 ] Mihai Budiu commented on CALCITE-6328: -- Another problem for these functions is the type inference

[jira] [Commented] (CALCITE-6328) The BigQuery functions SAFE_* do not match the BigQuery specification

2024-03-13 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17826904#comment-17826904 ] Mihai Budiu commented on CALCITE-6328: -- [~tanclary] I think you have written the code to implement

[jira] [Created] (CALCITE-6328) The BigQuery functions SAFE_* do not match the BigQuery specification

2024-03-13 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6328: Summary: The BigQuery functions SAFE_* do not match the BigQuery specification Key: CALCITE-6328 URL: https://issues.apache.org/jira/browse/CALCITE-6328 Project

[jira] [Comment Edited] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

2024-03-13 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825850#comment-17825850 ] James Duong edited comment on CALCITE-6309 at 3/13/24 10:27 PM: Thanks

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries)

2024-03-13 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: - Summary: Add REGEXP_LIKE function (enabled in MySQL, Oracle, PostgreSQL and Spark libraries

[jira] [Updated] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6322: Labels: pull-request-available (was: ) > Casts to DECIMAL types are igno

[jira] [Closed] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-13 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu closed CALCITE-6324. Resolution: Invalid > Type inferred for result of STDDEV, VAR_SAMP, etc. is incorr

[jira] [Commented] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-13 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17826853#comment-17826853 ] Mihai Budiu commented on CALCITE-6324: -- Upon further reflection I think that leaving the types

[jira] [Commented] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-13 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17826852#comment-17826852 ] Mihai Budiu commented on CALCITE-6324: -- Indeed, it is not clear what the precision and scale

[jira] [Created] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

2024-03-13 Thread Claude Brisson (Jira)
Claude Brisson created CALCITE-6327: --- Summary: getValidatedNodeTypeIfKnown should never throw Key: CALCITE-6327 URL: https://issues.apache.org/jira/browse/CALCITE-6327 Project: Calcite

[jira] [Commented] (CALCITE-6193) If a query has more than one subexpression that matches a materialized view, only the first is substituted

2024-03-13 Thread Mou Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825926#comment-17825926 ] Mou Wu commented on CALCITE-6193: - [~jiajunbernoulli] OK, can you review my PR again? we can check

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql, Spark library)

2024-03-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6325: Labels: pull-request-available (was: ) > Add LOG function (enabled in Mysql, Sp

[jira] [Commented] (CALCITE-3369) In LatticeSuggester, recommend lattices based on UNION queries

2024-03-12 Thread allendang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825890#comment-17825890 ] allendang commented on CALCITE-3369: Excuse me, does anyone follow up on this issue now

[jira] [Comment Edited] (CALCITE-5976) Function ARRAY_PREPEND/ARRAY_APPEND/ARRAY_INSERT gives exception when inserted element type not equals array component type

2024-03-12 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825889#comment-17825889 ] Ran Tao edited comment on CALCITE-5976 at 3/13/24 2:44 AM: --- Fixed via https

[jira] [Resolved] (CALCITE-5976) Function ARRAY_PREPEND/ARRAY_APPEND/ARRAY_INSERT gives exception when inserted element type not equals array component type

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

[jira] [Assigned] (CALCITE-6325) Add LOG function (enabled in Mysql, Spark library)

2024-03-12 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6325: --- Assignee: Caican Cai > Add LOG function (enabled in Mysql, Spark libr

[jira] [Created] (CALCITE-6326) Add LOG10 and LN function (enabled in Mysql, Spark library)

2024-03-12 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6326: --- Summary: Add LOG10 and LN function (enabled in Mysql, Spark library) Key: CALCITE-6326 URL: https://issues.apache.org/jira/browse/CALCITE-6326 Project: Calcite

[jira] [Created] (CALCITE-6325) Add LOG function (enabled in Mysql, Spark library)

2024-03-12 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6325: --- Summary: Add LOG function (enabled in Mysql, Spark library) Key: CALCITE-6325 URL: https://issues.apache.org/jira/browse/CALCITE-6325 Project: Calcite Issue

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

2024-03-12 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825883#comment-17825883 ] Caican Cai commented on CALCITE-6312: - [~tanclary] [~jduong] I want to open another PR to adapt

[jira] [Commented] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825877#comment-17825877 ] Julian Hyde commented on CALCITE-6324: -- You can't say the type is 'incorrect' when the standard

[jira] [Comment Edited] (CALCITE-6301) Extend ‘Must-filter’ columns to support a conditional bypass list

2024-03-12 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825861#comment-17825861 ] Oliver Lee edited comment on CALCITE-6301 at 3/13/24 12:00 AM

[jira] [Commented] (CALCITE-6301) Extend ‘Must-filter’ columns to support a conditional bypass list

2024-03-12 Thread Oliver Lee (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825861#comment-17825861 ] Oliver Lee commented on CALCITE-6301: - [~julianhyde]  We discussed adding in two more test cases

[jira] [Assigned] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-12 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6324: Assignee: Mihai Budiu > Type inferred for result of STDDEV, VAR_SAMP, etc. is incorr

[jira] [Updated] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-12 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6324: - Fix Version/s: 1.37.0 > Type inferred for result of STDDEV, VAR_SAMP, etc. is incorr

[jira] [Updated] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6324: Labels: pull-request-available (was: ) > Type inferred for result of STDDEV, VAR_S

[jira] [Created] (CALCITE-6324) Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

2024-03-12 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6324: Summary: Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect Key: CALCITE-6324 URL: https://issues.apache.org/jira/browse/CALCITE-6324 Project: Calcite

[jira] [Commented] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825857#comment-17825857 ] James Duong commented on CALCITE-6309: -- Sure, let's have all libraries support the common subset

[jira] [Commented] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825856#comment-17825856 ] Julian Hyde commented on CALCITE-6309: -- Thank you for doing this excellent research. I think

[jira] [Comment Edited] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825850#comment-17825850 ] James Duong edited comment on CALCITE-6309 at 3/12/24 10:56 PM: Thanks

[jira] [Commented] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825850#comment-17825850 ] James Duong commented on CALCITE-6309: -- Thanks. Yes we can do that. I have been investigating

[jira] [Commented] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825839#comment-17825839 ] Julian Hyde commented on CALCITE-6309: -- I think it would be OK (and simpler) to make the third

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6309: Labels: pull-request-available (was: ) > Add REGEXP_LIKE function (enabled in Postg

[jira] [Updated] (CALCITE-6309) Add REGEXP_LIKE function (enabled in Postgres library)

2024-03-12 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: - Summary: Add REGEXP_LIKE function (enabled in Postgres library) (was: Support PostgreSQL

[jira] [Commented] (CALCITE-6209) Long queries are failing with "java.net.SocketTimeoutException: Read timed out" after 3 minutes

2024-03-12 Thread Istvan Toth (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825775#comment-17825775 ] Istvan Toth commented on CALCITE-6209: -- Resolved in https://github.com/apache/calcite-avatica

[jira] [Resolved] (CALCITE-6323) Serialize return type during RelJson.toJson(RexNode node) for SqlKind.SAFE_CAST

2024-03-12 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-6323. --- Resolution: Fixed Merged via [b412fa4|https://github.com/apache/calcite/commit

[jira] [Commented] (CALCITE-6209) Long queries are failing with "java.net.SocketTimeoutException: Read timed out" after 3 minutes

2024-03-12 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825753#comment-17825753 ] Julian Hyde commented on CALCITE-6209: -- [~stoty], Please add a link to the commit on main branch

[jira] [Updated] (CALCITE-6323) Serialize return type during RelJson.toJson(RexNode node) for SqlKind.SAFE_CAST

2024-03-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6323: Labels: pull-request-available (was: ) > Serialize return type during RelJson.toJ

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825725#comment-17825725 ] Maksim Zhuravkov commented on CALCITE-6322: --- [~mbudiu] Thank you for clarification. > Ca

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825724#comment-17825724 ] Mihai Budiu commented on CALCITE-6322: -- 1.0 or 1 is the right result - the formatting depends

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825723#comment-17825723 ] Maksim Zhuravkov commented on CALCITE-6322: --- What of version of Postgres/MySQL were used

[jira] [Updated] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated CALCITE-6322: -- Attachment: (was: image.png) > Casts to DECIMAL types are igno

[jira] [Updated] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated CALCITE-6322: -- Attachment: image.png > Casts to DECIMAL types are igno

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825719#comment-17825719 ] Mihai Budiu commented on CALCITE-6322: -- In the other issue the value of the literal correctly

[jira] [Commented] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-03-12 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825692#comment-17825692 ] Maksim Zhuravkov commented on CALCITE-6322: --- I reported a similar issue (CALCITE-5794) some

[jira] [Comment Edited] (CALCITE-6138) Parser does not accept TIMESTAMP WITH TIME ZONE as a data type

2024-03-12 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825690#comment-17825690 ] Sergey Nuyanzin edited comment on CALCITE-6138 at 3/12/24 2:05 PM

[jira] [Commented] (CALCITE-6138) Parser does not accept TIMESTAMP WITH TIME ZONE as a data type

2024-03-12 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825690#comment-17825690 ] Sergey Nuyanzin commented on CALCITE-6138: -- Merged

[jira] [Updated] (CALCITE-6299) Support JOIN in Arrow adapter

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6299: Summary: Support JOIN in Arrow adapter (was: Support JOIN in arrow adapter) > Support J

[jira] [Updated] (CALCITE-6295) Support IS NOT NULL in Arrow adapter

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6295: Summary: Support IS NOT NULL in Arrow adapter (was: Support IS NOT NULL in arrow adapter

[jira] [Updated] (CALCITE-6296) Support IS NULL in Arrow adapter

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6296: Summary: Support IS NULL in Arrow adapter (was: Support IS NULL in arrow adapter) > Supp

[jira] [Updated] (CALCITE-6298) Support UNION in Arrow adapter

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6298: Summary: Support UNION in Arrow adapter (was: Support UNION in arrow adapter) > Support UN

[jira] [Updated] (CALCITE-6293) Support OR condition in Arrow adapter

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6293: Summary: Support OR condition in Arrow adapter (was: Support OR condition in arrow adapter

[jira] [Updated] (CALCITE-6294) Support IN filter in Arrow adapter

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6294: Summary: Support IN filter in Arrow adapter (was: Support IN filter in arrow adapter

[jira] [Updated] (CALCITE-6292) Support more Arrow type

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6292: Summary: Support more Arrow type (was: Support more arrow type) > Support more Arrow t

[jira] [Updated] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

2024-03-12 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6300: Summary: Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType

[jira] [Resolved] (CALCITE-6209) Long queries are failing with "java.net.SocketTimeoutException: Read timed out" after 3 minutes

2024-03-12 Thread Istvan Toth (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth resolved CALCITE-6209. -- Fix Version/s: avatica-1.25.0 Resolution: Fixed Committed to main. Thanks

[jira] [Assigned] (CALCITE-6209) Long queries are failing with "java.net.SocketTimeoutException: Read timed out" after 3 minutes

2024-03-12 Thread Istvan Toth (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth reassigned CALCITE-6209: Assignee: Istvan Toth > Long queries are failing with "java.net.SocketTimeoutE

<    6   7   8   9   10   11   12   13   14   15   >