[jira] [Updated] (CALCITE-5131) Remove redundant type cast

2022-05-06 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5131: Labels: pull-request-available (was: ) > Remove redundant type cast > --

[jira] [Resolved] (CALCITE-5095) Support Java 18 and Guava 31.1-jre

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5095. -- Resolution: Fixed Fixed in Calcite in [ff783a8|https://github.com/apache/calcite/commit/ff78

[jira] [Commented] (CALCITE-4897) Set operation in DML, implicit type conversion is not complete

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533114#comment-17533114 ] Julian Hyde commented on CALCITE-4897: -- Reviewing PR 2615 again: * This is a trick

[jira] [Updated] (CALCITE-5132) Scalar IN subquery returns UNKNOWN instead of FALSE when key is partially NULL

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5132: - Description: Scalar IN subquery returns UNKNOWN instead of FALSE when key is partially NULL. T

[jira] [Updated] (CALCITE-5132) Scalar IN subquery returns UNKNOWN instead of FALSE when key is partially NULL

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5132: - Description: Scalar IN subquery returns UNKNOWN instead of FALSE when key is partially NULL. T

[jira] [Updated] (CALCITE-5132) Scalar IN subquery returns UNKNOWN instead of FALSE when key is partially NULL

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5132: - Summary: Scalar IN subquery returns UNKNOWN instead of FALSE when key is partially NULL (was:

[jira] [Commented] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533067#comment-17533067 ] Julian Hyde commented on CALCITE-5132: -- [~nobigo], Yes, when I add that command to

[jira] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132 ] Julian Hyde deleted comment on CALCITE-5132: -- was (Author: julianhyde): [~nobigo], That's a workaround, not a fix. > When the IN-list including a NULL value is converted to Values as a SCA

[jira] [Commented] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533062#comment-17533062 ] Julian Hyde commented on CALCITE-5132: -- [~nobigo], That's a workaround, not a fix.

[jira] [Created] (CALCITE-5136) Avatica build (or CI) must fail if there are deprecation warnings

2022-05-06 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-5136: Summary: Avatica build (or CI) must fail if there are deprecation warnings Key: CALCITE-5136 URL: https://issues.apache.org/jira/browse/CALCITE-5136 Project: Calcite

[jira] [Commented] (CALCITE-5135) Planner#parse can't parse DAY() function

2022-05-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533015#comment-17533015 ] Julian Hyde commented on CALCITE-5135: -- Is {{DAY}} a reserved keyword? > Planner#

[jira] [Commented] (CALCITE-5135) Planner#parse can't parse DAY() function

2022-05-06 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532895#comment-17532895 ] Ruben Q L commented on CALCITE-5135: According to Calcite documentation: https://c

[jira] [Created] (CALCITE-5135) Planner#parse can't parse DAY() function

2022-05-06 Thread Mitsunori Komatsu (Jira)
Mitsunori Komatsu created CALCITE-5135: -- Summary: Planner#parse can't parse DAY() function Key: CALCITE-5135 URL: https://issues.apache.org/jira/browse/CALCITE-5135 Project: Calcite Issu

[jira] [Commented] (CALCITE-5134) Queries with subquery inside select list does not work if subquery uses table from left join

2022-05-06 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532873#comment-17532873 ] Benchao Li commented on CALCITE-5134: - [~dmsysolyatin] This error is same problem i

[jira] [Commented] (CALCITE-5125) Extend "||" operator to work with arrays

2022-05-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532768#comment-17532768 ] Dmitry Sysolyatin commented on CALCITE-5125: I didn't plan to implement all

[jira] [Assigned] (CALCITE-5111) jekyll-cache directory should be ignored by git

2022-05-06 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li reassigned CALCITE-5111: --- Assignee: Benchao Li > jekyll-cache directory should be ignored by git > -

[jira] [Resolved] (CALCITE-5111) jekyll-cache directory should be ignored by git

2022-05-06 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-5111. -- Resolution: Fixed Fixed in [https://github.com/apache/calcite/commit/2e446f2a8a63aeff2513dcb

[jira] [Commented] (CALCITE-5125) Extend "||" operator to work with arrays

2022-05-06 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532721#comment-17532721 ] Chunwei Lei commented on CALCITE-5125: -- BTW, PostgreSQL supports different kinds o

[jira] [Commented] (CALCITE-5126) Implicit column alias for single-column UNNEST should work with any single-column UNNEST’s input

2022-05-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532718#comment-17532718 ] Dmitry Sysolyatin commented on CALCITE-5126: Can someone review PR? > Impl

[jira] [Updated] (CALCITE-5126) Implicit column alias for single-column UNNEST should work with any single-column UNNEST’s input

2022-05-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin updated CALCITE-5126: --- Labels: pull-request-available (was: ) > Implicit column alias for single-column U

[jira] [Commented] (CALCITE-5125) Extend "||" operator to work with arrays

2022-05-06 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532714#comment-17532714 ] Chunwei Lei commented on CALCITE-5125: -- Thank you for your PR, [~dmsysolyatin] . I

[jira] [Commented] (CALCITE-5131) Remove redundant type cast

2022-05-06 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532706#comment-17532706 ] Chunwei Lei commented on CALCITE-5131: -- I couldn’t agree with you more.  > Remove

[jira] [Commented] (CALCITE-5134) Queries with subquery inside select list does not work if subquery uses table from left join

2022-05-06 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532681#comment-17532681 ] Dmitry Sysolyatin commented on CALCITE-5134: [~libenchao] Queries from the