You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/09/24 06:18:00 UTC
[jira] [Updated] (IGNITE-15582) Calcite. Numerous errors with
any\all scalars.
[ https://issues.apache.org/jira/browse/IGNITE-15582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Stanilovsky updated IGNITE-15582:
----------------------------------------
Description:
{{ /subquery/any_all/test_scalar_any_all.test[_ignore] }}
{noformat}
SELECT 1 = ALL(SELECT 1)
{noformat}
{noformat}
Unexpected error at query optimizer.
java.lang.AssertionError
at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteSome(SubQueryRemoveRule.java:162)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:92)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:603)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.access$200(SubQueryRemoveRule.java:71)
at org.apache.calcite.rel.rules.SubQueryRemoveRule$Config.lambda$static$1(SubQueryRemoveRule.java:685)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.onMatch(SubQueryRemoveRule.java:82)
at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:341)
{noformat}
{noformat}
SELECT 1 = ALL(SELECT NULL)
{noformat}
{noformat}
Unexpected error at query optimizer.
java.lang.AssertionError
at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteSome(SubQueryRemoveRule.java:162)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:92)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:603)
{noformat}
{noformat}
SELECT 1 IN (SELECT NULL)
{noformat}
{noformat}
Unexpected error at query optimizer.
java.lang.AssertionError: Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(BOOLEAN NOT NULL EXPR$0) NOT NULL
converted type:
RecordType(BOOLEAN EXPR$0) NOT NULL
rel:
LogicalProject(EXPR$0=[IN(1, {
LogicalValues(tuples=[[{ null }]])
})])
LogicalValues(tuples=[[{ 0 }]])
at org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:485)
at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:600)
at org.apache.ignite.internal.processors.query.calcite.prepare.IgnitePlanner.rel(IgnitePlanner.java:214)
{noformat}
was:
{{ /subquery/any_all/test_scalar_any_all.test[_ignore] }}
{noformat}
SELECT 1 = ALL(SELECT 1)
{noformat}
{noformat}
Unexpected error at query optimizer.
java.lang.AssertionError
at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteSome(SubQueryRemoveRule.java:162)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:92)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:603)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.access$200(SubQueryRemoveRule.java:71)
at org.apache.calcite.rel.rules.SubQueryRemoveRule$Config.lambda$static$1(SubQueryRemoveRule.java:685)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.onMatch(SubQueryRemoveRule.java:82)
at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:341)
{noformat}
{noformat}
SELECT 1 = ALL(SELECT NULL)
{noformat}
{noformat}
Unexpected error at query optimizer.
java.lang.AssertionError
at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteSome(SubQueryRemoveRule.java:162)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:92)
at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:603)
{noformat}
> Calcite. Numerous errors with any\all scalars.
> ----------------------------------------------
>
> Key: IGNITE-15582
> URL: https://issues.apache.org/jira/browse/IGNITE-15582
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> {{ /subquery/any_all/test_scalar_any_all.test[_ignore] }}
> {noformat}
> SELECT 1 = ALL(SELECT 1)
> {noformat}
> {noformat}
> Unexpected error at query optimizer.
> java.lang.AssertionError
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteSome(SubQueryRemoveRule.java:162)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:92)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:603)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.access$200(SubQueryRemoveRule.java:71)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule$Config.lambda$static$1(SubQueryRemoveRule.java:685)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.onMatch(SubQueryRemoveRule.java:82)
> at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:341)
> {noformat}
> {noformat}
> SELECT 1 = ALL(SELECT NULL)
> {noformat}
> {noformat}
> Unexpected error at query optimizer.
> java.lang.AssertionError
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteSome(SubQueryRemoveRule.java:162)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:92)
> at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:603)
> {noformat}
> {noformat}
> SELECT 1 IN (SELECT NULL)
> {noformat}
> {noformat}
> Unexpected error at query optimizer.
> java.lang.AssertionError: Conversion to relational algebra failed to preserve datatypes:
> validated type:
> RecordType(BOOLEAN NOT NULL EXPR$0) NOT NULL
> converted type:
> RecordType(BOOLEAN EXPR$0) NOT NULL
> rel:
> LogicalProject(EXPR$0=[IN(1, {
> LogicalValues(tuples=[[{ null }]])
> })])
> LogicalValues(tuples=[[{ 0 }]])
> at org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:485)
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:600)
> at org.apache.ignite.internal.processors.query.calcite.prepare.IgnitePlanner.rel(IgnitePlanner.java:214)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)