[jira] [Created] (CALCITE-5132) When the IN-list that include NUll value is converted to Values as a SCALA subquery will return wrong result

2022-05-04 Thread xiong duan (Jira)
xiong duan created CALCITE-5132: --- Summary: When the IN-list that include NUll value is converted to Values as a SCALA subquery will return wrong result Key: CALCITE-5132 URL:

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

2022-05-04 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-5131: Summary: Remove redundant type cast Key: CALCITE-5131 URL: https://issues.apache.org/jira/browse/CALCITE-5131 Project: Calcite Issue Type: Improvement

[VOTE] Release Apache Calcite Avatica 1.21.0 (release candidate 0)

2022-05-04 Thread Francis Chuang
Hi all, I have created a build for Apache Calcite Avatica 1.21.0, release candidate 0. Thanks to everyone who has contributed to this release. You can read the release notes here: https://github.com/apache/calcite-avatica/blob/avatica-1.21.0-rc0/site/_docs/history.md The commit to be voted

Re: Incorrect plan for complex query

2022-05-04 Thread Julian Hyde
Those queries, and the ones in the 5127 test case, look valid to me. If "books" is an array then your first query is requesting an array of arrays. If that's not what you want, you should probably use UNNEST. On Tue, May 3, 2022 at 5:40 AM Dmitry Sysolyatin wrote: > > I found more failing

[jira] [Created] (CALCITE-5130) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when union VARCHAR literal and CAST(null AS INTEGER)

2022-05-04 Thread Yingyu (Jira)
Yingyu created CALCITE-5130: --- Summary: AssertionError: "Conversion to relational algebra failed to preserve datatypes" when union VARCHAR literal and CAST(null AS INTEGER) Key: CALCITE-5130 URL: