[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-11 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711181#comment-17711181 ] Mihai Budiu commented on CALCITE-5615: -- I believe that the suite was built to test correctness of

[jira] [Created] (CALCITE-5641) Use materialized views with prepareStatement

2023-04-11 Thread shampoo liu (Jira)
shampoo liu created CALCITE-5641: Summary: Use materialized views with prepareStatement Key: CALCITE-5641 URL: https://issues.apache.org/jira/browse/CALCITE-5641 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-11 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711169#comment-17711169 ] LakeShen commented on CALCITE-5615: --- Hi [~mbudiu],this sounds interesting.I have two questions about

[jira] [Commented] (CALCITE-5639) RexSimplify should remove IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711168#comment-17711168 ] Chunwei Lei commented on CALCITE-5639: -- I can't agree more. It would be great if we can find a

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

2023-04-11 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711149#comment-17711149 ] Mihai Budiu commented on CALCITE-5615: -- I have filed this PR

[jira] [Updated] (CALCITE-5636) Consult type mappings when coercing types.

2023-04-11 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5636: Labels: pull-request-available (was: ) > Consult type mappings when coercing types. >

[jira] [Updated] (CALCITE-5639) RexSimplify should remove IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5639: - Summary: RexSimplify should remove IS NOT NULL check when LIKE comparison is present (was:

[jira] [Commented] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1776#comment-1776 ] Julian Hyde commented on CALCITE-5639: -- This seems like a more general problem. For example, it's

[jira] [Commented] (CALCITE-5624) Cannot parse array function for Spark Dialect

2023-04-11 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711079#comment-17711079 ] Guillaume Massé commented on CALCITE-5624: -- Okay, I figured it out, it's because the double

[jira] [Commented] (CALCITE-5636) Consult type mappings when coercing types.

2023-04-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17711064#comment-17711064 ] Julian Hyde commented on CALCITE-5636: -- I am skeptical that this is a bug. The type mappings

[jira] [Created] (CALCITE-5640) Implement SAFE_ADD function

2023-04-11 Thread Dan Zou (Jira)
Dan Zou created CALCITE-5640: Summary: Implement SAFE_ADD function Key: CALCITE-5640 URL: https://issues.apache.org/jira/browse/CALCITE-5640 Project: Calcite Issue Type: Sub-task

[jira] [Commented] (CALCITE-5632) Query with ORDER BY and null values NullPointer exception

2023-04-11 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17710967#comment-17710967 ] Jiajun Xie commented on CALCITE-5632: - In my opinion, if a non-nullable column has a null value, an

[jira] [Commented] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17710942#comment-17710942 ] Leonid Chistov commented on CALCITE-5639: - https://github.com/apache/calcite/pull/3143 >

[jira] [Updated] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5639: Labels: pull-request-available (was: ) > RexSimplify not removes IS NOT NULL check when

[jira] [Updated] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5639: Priority: Minor (was: Major) > RexSimplify not removes IS NOT NULL check when LIKE

[jira] [Updated] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5639: Description: Consider query like {code:java} select r_reason_desc from reason where

[jira] [Updated] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Leonid Chistov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Chistov updated CALCITE-5639: Description: Consider query like   {code:java} select r_reason_desc from reason where

[jira] [Created] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

2023-04-11 Thread Leonid Chistov (Jira)
Leonid Chistov created CALCITE-5639: --- Summary: RexSimplify not removes IS NOT NULL check when LIKE comparison is present Key: CALCITE-5639 URL: https://issues.apache.org/jira/browse/CALCITE-5639

[jira] [Closed] (CALCITE-5632) Query with ORDER BY and null values NullPointer exception

2023-04-11 Thread Kirill Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kirill Kim closed CALCITE-5632. --- Resolution: Not A Problem > Query with ORDER BY and null values NullPointer exception >

[jira] [Commented] (CALCITE-5632) Query with ORDER BY and null values NullPointer exception

2023-04-11 Thread Kirill Kim (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17710836#comment-17710836 ] Kirill Kim commented on CALCITE-5632: - I found problem in my code, I created RelDataType not

[jira] [Commented] (CALCITE-3959) Implement INSTR function

2023-04-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17710436#comment-17710436 ] Julian Hyde commented on CALCITE-3959: -- Again, I recommend adding two arguments to POSITION and