Aleksey Plekhanov created IGNITE-25353:
------------------------------------------
Summary: Calcite engine. NVL with correlated subquery can't be
planned
Key: IGNITE-25353
URL: https://issues.apache.org/jira/browse/IGNITE-25353
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
Reproducer:
{code:java}
/** */
@Test
public void testNvl() throws Exception {
IgniteSchema schema = createSchema(
createTable("T1", IgniteDistributions.single(), "ID", Integer.class),
createTable("T2", IgniteDistributions.single(), "ID", Integer.class)
);
assertPlan("SELECT NVL((SELECT MAX('0') FROM T1 WHERE T1.ID = T2.ID), '1')
FROM T2", schema,
nodeOrAnyChild(isTableScan("T2")));
} {code}
Fails with:
{noformat}
Unexpected error at query optimizer. java.lang.AssertionError: Conversion to
relational algebra failed to preserve datatypes:validated
type:RecordType(CHAR(1) CHARACTER SET "UTF-8" NOT NULL EXPR$0) NOT
NULLconverted type:RecordType(CHAR(1) CHARACTER SET "UTF-8" EXPR$0) NOT
NULLrel:LogicalProject(variablesSet=[[$cor0]], EXPR$0=[CASE(IS NOT
NULL($SCALAR_QUERY({LogicalAggregate(group=[{}], EXPR$0=[MAX($0)])
LogicalProject($f0=[_UTF-8'0']) LogicalFilter(condition=[=($0, $cor0.ID)])
IgniteLogicalTableScan(table=[[PUBLIC, T1]])})),
$SCALAR_QUERY({LogicalAggregate(group=[{}], EXPR$0=[MAX($0)])
LogicalProject($f0=[_UTF-8'0']) LogicalFilter(condition=[=($0, $cor0.ID)])
IgniteLogicalTableScan(table=[[PUBLIC, T1]])}), _UTF-8'1')])
IgniteLogicalTableScan(table=[[PUBLIC, T2]])
at
org.apache.calcite.sql2rel.SqlToRelConverter.checkConvertedType(SqlToRelConverter.java:510)
~[calcite-core-1.37.0.jar:1.37.0] at
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:625)
~[calcite-core-1.37.0.jar:1.37.0] at
org.apache.ignite.internal.processors.query.calcite.prepare.IgnitePlanner.rel(IgnitePlanner.java:344)
~[classes/:?] at
org.apache.ignite.internal.processors.query.calcite.prepare.PlannerHelper.optimize(PlannerHelper.java:111)
[classes/:?] at
org.apache.ignite.internal.processors.query.calcite.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:295)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.calcite.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:282)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.calcite.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:483)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.calcite.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:503)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.calcite.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:462)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.calcite.planner.JoinColocationPlannerTest.testNvl(JoinColocationPlannerTest.java:235)
[test-classes/:?] at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?] at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:?] at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566)
~[?:?] at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
[junit-4.12.jar:4.12] at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
[junit-4.12.jar:4.12] at
org.apache.ignite.testframework.junits.GridAbstractTest$6.run(GridAbstractTest.java:2491)
[test-classes/:?] at java.base/java.lang.Thread.run(Thread.java:829)
[?:?]{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
