Iurii Gerzhedovich created IGNITE-28575:
-------------------------------------------
Summary: Flaky test
NumericMergeSourcesCoercionTest.mergeWithLiteralValue
Key: IGNITE-28575
URL: https://issues.apache.org/jira/browse/IGNITE-28575
Project: Ignite
Issue Type: Improvement
Components: sql ai3
Reporter: Iurii Gerzhedovich
The test
[org.apache.ignite.internal.sql.engine.planner.datatypes.NumericMergeSourcesCoercionTest.mergeWithLiteralValue([2]
TINYINT_SMALLINT, Operand that is
CAST(..):TINYINT)|https://ci.ignite.apache.org/buildConfiguration/ApacheIgnite3x_Test_RunAllTestsCustomJDK/10384795]
is flaky
{code:java}
org.apache.ignite.internal.sql.engine.planner.datatypes.NumericMergeSourcesCoercionTest.mergeWithLiteralValue([2]
TINYINT_SMALLINT, Operand that is CAST(..):TINYINT)
04:29:04 org.opentest4j.AssertionFailedError: Failed to validate plan (
Expected: Operand that is CAST(..):TINYINT
but: was <-128:TINYINT> of type TINYINT):
TableModify(table=[[PUBLIC, T1]], operation=[MERGE],
updateColumnList=[[C1]], flattened=[false], tableId=[9832]): rowcount = 1.5E9,
cumulative cost = IgniteCost [rowCount=1.500400003E9, cpu=1.502200003E9,
memory=1160003.0, io=3.0, network=3.0], id = 2947720
Project(C1=[$1], $f1=[-128:TINYINT]): rowcount = 1.5E9, cumulative
cost = IgniteCost [rowCount=1.500400002E9, cpu=1.502200002E9, memory=1160002.0,
io=2.0, network=2.0], id = 2947719
HashJoin(condition=[=($2, $0)], joinType=[inner]): rowcount =
1.5E9, cumulative cost = IgniteCost [rowCount=400000.0, cpu=2200000.0,
memory=1160000.0, io=0.0, network=0.0], id = 2947718
TableScan(table=[[PUBLIC, T2]], tableId=[9833], names=[[C2]],
requiredColumns=[[0]]): rowcount = 100000.0, cumulative cost = IgniteCost
[rowCount=100000.0, cpu=100000.0, memory=0.0, io=0.0, network=0.0], id = 2947641
TableScan(table=[[PUBLIC, T1]], tableId=[9832], names=[[C1,
C10]], projects=[[$t0, CAST($t0):SMALLINT]], requiredColumns=[[0]]): rowcount =
100000.0, cumulative cost = IgniteCost [rowCount=100000.0, cpu=100000.0,
memory=0.0, io=0.0, network=0.0], id = 2947644
04:29:04 org.opentest4j.AssertionFailedError: Failed to validate plan (
Expected: Operand that is CAST(..):TINYINT
but: was <-128:TINYINT> of type TINYINT):
TableModify(table=[[PUBLIC, T1]], operation=[MERGE],
updateColumnList=[[C1]], flattened=[false], tableId=[9832]): rowcount = 1.5E9,
cumulative cost = IgniteCost [rowCount=1.500400003E9, cpu=1.502200003E9,
memory=1160003.0, io=3.0, network=3.0], id = 2947720
Project(C1=[$1], $f1=[-128:TINYINT]): rowcount = 1.5E9, cumulative
cost = IgniteCost [rowCount=1.500400002E9, cpu=1.502200002E9, memory=1160002.0,
io=2.0, network=2.0], id = 2947719
HashJoin(condition=[=($2, $0)], joinType=[inner]): rowcount =
1.5E9, cumulative cost = IgniteCost [rowCount=400000.0, cpu=2200000.0,
memory=1160000.0, io=0.0, network=0.0], id = 2947718
TableScan(table=[[PUBLIC, T2]], tableId=[9833], names=[[C2]],
requiredColumns=[[0]]): rowcount = 100000.0, cumulative cost = IgniteCost
[rowCount=100000.0, cpu=100000.0, memory=0.0, io=0.0, network=0.0], id = 2947641
TableScan(table=[[PUBLIC, T1]], tableId=[9832], names=[[C1,
C10]], projects=[[$t0, CAST($t0):SMALLINT]], requiredColumns=[[0]]): rowcount =
100000.0, cumulative cost = IgniteCost [rowCount=100000.0, cpu=100000.0,
memory=0.0, io=0.0, network=0.0], id = 2947644
at
app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:42)
at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:150)
at
app//org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:537)
at
app//org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:507)
at
app//org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:488)
at
app//org.apache.ignite.internal.sql.engine.planner.datatypes.NumericMergeSourcesCoercionTest.mergeWithLiteralValue(NumericMergeSourcesCoercionTest.java:71)
at [email protected]/java.lang.reflect.Method.invoke(Method.java:568)
at [email protected]/java.util.Optional.ifPresent(Optional.java:178)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992)
at
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
at
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992)
at
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
at
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
at
[email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625)
at
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
at
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:276)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
at
[email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625)
at
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
at
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
at
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1511)
at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1511)
Caused by: java.lang.AssertionError:
Expected: Operand that is CAST(..):TINYINT
but: was <-128:TINYINT> of type TINYINT
at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
at
org.apache.ignite.internal.sql.engine.planner.datatypes.BaseTypeCoercionTest$15.matches(BaseTypeCoercionTest.java:694)
at
org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.assertPlan(AbstractPlannerTest.java:526)
... 51 more {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
