[jira] [Commented] (CALCITE-5759) SEARCH operator with special sarg is not fully simplified

2023-06-06 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729942#comment-17729942 ] xiong duan commented on CALCITE-5759: - I think this is reasonable.  +1 > SEARCH op

[jira] [Comment Edited] (CALCITE-5756) Add Join elimination optimization according to foreign-unique constraint in the catalog

2023-06-06 Thread Roman Kondakov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729935#comment-17729935 ] Roman Kondakov edited comment on CALCITE-5756 at 6/7/23 6:21 AM:

[jira] [Commented] (CALCITE-5756) Add Join elimination optimization according to foreign-unique constraint in the catalog

2023-06-06 Thread Roman Kondakov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729935#comment-17729935 ] Roman Kondakov commented on CALCITE-5756: - What is the difference with [Projec

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

2023-06-06 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729929#comment-17729929 ] libopeng commented on CALCITE-5743: --- [https://www.microsoft.com/en-us/research/wp-con

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

2023-06-06 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729919#comment-17729919 ] libopeng commented on CALCITE-5743: --- Rather than adding a join, could the existing jo

[jira] [Commented] (CALCITE-5761) DATE_TRUNC compile-time evaluation produces wrong results

2023-06-06 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729915#comment-17729915 ] Mihai Budiu commented on CALCITE-5761: -- [~tanclary]  I would appreciate if someon

[jira] [Created] (CALCITE-5761) DATE_TRUNC compile-time evaluation produces wrong results

2023-06-06 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-5761: Summary: DATE_TRUNC compile-time evaluation produces wrong results Key: CALCITE-5761 URL: https://issues.apache.org/jira/browse/CALCITE-5761 Project: Calcite

[jira] [Closed] (CALCITE-5760) SqlOperatorTest::testDateTrunc does not validate results

2023-06-06 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu closed CALCITE-5760. Resolution: Not A Problem > SqlOperatorTest::testDateTrunc does not validate results > --

[jira] [Commented] (CALCITE-5760) SqlOperatorTest::testDateTrunc does not validate results

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729903#comment-17729903 ] Tanner Clary commented on CALCITE-5760: --- [~mbudiu] Additionally, I have worked qu

[jira] [Commented] (CALCITE-5760) SqlOperatorTest::testDateTrunc does not validate results

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729899#comment-17729899 ] Tanner Clary commented on CALCITE-5760: --- [~mbudiu] Try running these tests from C

[jira] [Created] (CALCITE-5760) SqlOperatorTest::testDateTrunc does not validate results

2023-06-06 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-5760: Summary: SqlOperatorTest::testDateTrunc does not validate results Key: CALCITE-5760 URL: https://issues.apache.org/jira/browse/CALCITE-5760 Project: Calcite

[jira] [Assigned] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-06-06 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5704: - Assignee: jackylau > Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect > ---

[jira] [Commented] (CALCITE-5156) Support implicit number type cast for IN Sub-query

2023-06-06 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729880#comment-17729880 ] xiong duan commented on CALCITE-5156: - [~julianhyde] [~Chunwei Lei] Here is the bas

[jira] [Comment Edited] (CALCITE-5749) Join table with different database name and same table name will throw exception

2023-06-06 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729875#comment-17729875 ] xiong duan edited comment on CALCITE-5749 at 6/7/23 1:34 AM:

[jira] [Commented] (CALCITE-5749) Join table with different database name and same table name will throw exception

2023-06-06 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729875#comment-17729875 ] xiong duan commented on CALCITE-5749: - This is a valid SQL. So it's a bug in Calcit

[jira] [Updated] (CALCITE-5759) SEARCH operator with special sarg is not fully simplified

2023-06-06 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5759: Description: The minimal reproducer is to construct a RexCall with RexUnknownAs.FALSE as below:

[jira] [Created] (CALCITE-5759) SEARCH operator with special sarg is not fully simplified

2023-06-06 Thread Runkang He (Jira)
Runkang He created CALCITE-5759: --- Summary: SEARCH operator with special sarg is not fully simplified Key: CALCITE-5759 URL: https://issues.apache.org/jira/browse/CALCITE-5759 Project: Calcite I

[jira] [Commented] (CALCITE-5749) Join table with different database name and same table name will throw exception

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729864#comment-17729864 ] Julian Hyde commented on CALCITE-5749: -- Is that a bug in Calcite or in your query?

[jira] [Commented] (CALCITE-5729) Add BYTE_LENGTH function (enabled in BigQuery library)

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729863#comment-17729863 ] Julian Hyde commented on CALCITE-5729: -- I like that idea. If it's not too much wor

[jira] [Updated] (CALCITE-5758) Initialize connector info map to prevent panic

2023-06-06 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-5758: Issue Type: Bug (was: New Feature) > Initialize connector info map to prevent panic > --

[jira] [Resolved] (CALCITE-5758) Initialize connector info map to prevent panic

2023-06-06 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-5758. - Resolution: Fixed > Initialize connector info map to prevent panic > --

[jira] [Updated] (CALCITE-5758) Initialize connector info map to prevent panic

2023-06-06 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-5758: Summary: Initialize connector info map to prevent panic (was: Initialize connector info

[jira] [Created] (CALCITE-5758) Initialize connector info map

2023-06-06 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-5758: --- Summary: Initialize connector info map Key: CALCITE-5758 URL: https://issues.apache.org/jira/browse/CALCITE-5758 Project: Calcite Issue Type: New Featu

[jira] [Updated] (CALCITE-5709) Add TO_BASE32 and FROM_BASE32 functions (enabled in BigQuery library)

2023-06-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5709: Labels: pull-request-available (was: ) > Add TO_BASE32 and FROM_BASE32 functions (enable

[jira] [Commented] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729843#comment-17729843 ] Tanner Clary commented on CALCITE-5757: --- [~julianhyde] Yeah I'm happy to verify t

[jira] [Updated] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5757: Labels: pull-request-available (was: ) > Incorrect return type for BigQuery TRUNC functi

[jira] [Commented] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729839#comment-17729839 ] Julian Hyde commented on CALCITE-5757: -- [~tanclary], Maybe it's not just the {{TRU

[jira] [Updated] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5757: -- Summary: Incorrect return type for BigQuery TRUNC functions (was: Incorrect return type for

[jira] [Updated] (CALCITE-5757) Incorrect return type for BigQuery TRUNCfunctions

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5757: -- Summary: Incorrect return type for BigQuery TRUNCfunctions (was: Incorrect return type for B

[jira] [Updated] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5757: -- Description: This is written in Calcite terms, a Calcite {{TIMESTAMP}} is a BigQuery {{DATET

[jira] [Updated] (CALCITE-5757) Incorrect return type for BigQuery TIMESTAMP functions

2023-06-06 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5757: -- Description: This is written in Calcite terms, a Calcite {{TIMESTAMP}} is a BigQuery {{DATET

[jira] [Commented] (CALCITE-5757) Incorrect return type for BigQuery TIMESTAMP functions

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729815#comment-17729815 ] Julian Hyde commented on CALCITE-5757: -- Makes sense. Thanks for clearly distinguis

[jira] [Created] (CALCITE-5757) Incorrect return type for BigQuery TIMESTAMP functions

2023-06-06 Thread Tanner Clary (Jira)
Tanner Clary created CALCITE-5757: - Summary: Incorrect return type for BigQuery TIMESTAMP functions Key: CALCITE-5757 URL: https://issues.apache.org/jira/browse/CALCITE-5757 Project: Calcite

[jira] [Created] (CALCITE-5756) Add Join elimination optimization according to foreign-unique constraint in the catalog

2023-06-06 Thread winds (Jira)
winds created CALCITE-5756: -- Summary: Add Join elimination optimization according to foreign-unique constraint in the catalog Key: CALCITE-5756 URL: https://issues.apache.org/jira/browse/CALCITE-5756 Project

[jira] [Updated] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5743: - Summary: Query gives incorrect result when COUNT appears in the correlated subquery select list

[jira] [Commented] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

2023-06-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729783#comment-17729783 ] Julian Hyde commented on CALCITE-5743: -- Rather than adding a join, could the exist

[jira] [Commented] (CALCITE-5743) An error occurs when count appears in the correlated subquery select list

2023-06-06 Thread libopeng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729691#comment-17729691 ] libopeng commented on CALCITE-5743: ---   {code:java} LogicalProject(A=[$0])   LogicalJo

[jira] [Assigned] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-06 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5751: - Assignee: jackylau > Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark di

[jira] [Comment Edited] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729653#comment-17729653 ] Xin Chen edited comment on CALCITE-5733 at 6/6/23 8:27 AM: --- T

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Description: Simplification seem to not take into account that the specified field is of array type.

[jira] [Comment Edited] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729653#comment-17729653 ] Xin Chen edited comment on CALCITE-5733 at 6/6/23 8:24 AM: --- T

[jira] [Comment Edited] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729653#comment-17729653 ] Xin Chen edited comment on CALCITE-5733 at 6/6/23 8:22 AM: --- T

[jira] [Commented] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729653#comment-17729653 ] Xin Chen commented on CALCITE-5733: --- The current solution I can think of is this, as

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Attachment: screenshot-4.png > simplify should also simplify for array type > ---

[jira] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733 ] Xin Chen deleted comment on CALCITE-5733: --- was (Author: JIRAUSER298666): I am currently not sure how to return a comparison instance for 'CAST (ARRAY...' here yet. !screenshot-3.png! > si

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread Xin Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xin Chen updated CALCITE-5733: -- Component/s: core > simplify should also simplify for array type > --

[jira] [Updated] (CALCITE-5733) simplify should also simplify for array type

2023-06-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5733: Labels: pull-request-available (was: ) > simplify should also simplify for array type >

[jira] [Commented] (CALCITE-5729) Add BYTE_LENGTH function (enabled in BigQuery library)

2023-06-06 Thread Dan Zou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729617#comment-17729617 ] Dan Zou commented on CALCITE-5729: -- [~julianhyde] Thanks for the information. After I