Sergey Nuyanzin created FLINK-29237:
---------------------------------------
Summary: CalcITCase.testOrWithIsNullPredicate fails after update
to calcite 1.27
Key: FLINK-29237
URL: https://issues.apache.org/jira/browse/FLINK-29237
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API, Table SQL / Planner
Reporter: Sergey Nuyanzin
{noformat}
Sep 07 11:25:08 java.lang.AssertionError:
Sep 07 11:25:08
Sep 07 11:25:08 Results do not match for query:
Sep 07 11:25:08
Sep 07 11:25:08 SELECT * FROM NullTable3 AS T
Sep 07 11:25:08 WHERE T.a = 1 OR T.a = 3 OR T.a IS NULL
Sep 07 11:25:08
Sep 07 11:25:08
Sep 07 11:25:08 Results
Sep 07 11:25:08 == Correct Result - 4 == == Actual Result - 2 ==
Sep 07 11:25:08 +I[1, 1, Hi] +I[1, 1, Hi]
Sep 07 11:25:08 +I[3, 2, Hello world] +I[3, 2, Hello world]
Sep 07 11:25:08 !+I[null, 999, NullTuple]
Sep 07 11:25:08 !+I[null, 999, NullTuple]
Sep 07 11:25:08
Sep 07 11:25:08 Plan:
Sep 07 11:25:08 == Abstract Syntax Tree ==
Sep 07 11:25:08 LogicalProject(inputs=[0..2])
Sep 07 11:25:08 +- LogicalFilter(condition=[OR(=($0, 1), =($0, 3), IS
NULL($0))])
Sep 07 11:25:08 +- LogicalTableScan(table=[[default_catalog,
default_database, NullTable3]])
Sep 07 11:25:08
Sep 07 11:25:08 == Optimized Logical Plan ==
Sep 07 11:25:08 Calc(select=[a, b, c], where=[SEARCH(a, Sarg[1, 3; NULL AS
TRUE])])
Sep 07 11:25:08 +- BoundedStreamScan(table=[[default_catalog, default_database,
NullTable3]], fields=[a, b, c])
Sep 07 11:25:08
Sep 07 11:25:08
Sep 07 11:25:08 at org.junit.Assert.fail(Assert.java:89)
Sep 07 11:25:08 at
org.apache.flink.table.planner.runtime.utils.BatchTestBase.$anonfun$check$1(BatchTestBase.scala:154)
Sep 07 11:25:08 at
org.apache.flink.table.planner.runtime.utils.BatchTestBase.$anonfun$check$1$adapted(BatchTestBase.scala:147)
Sep 07 11:25:08 at scala.Option.foreach(Option.scala:257)
Sep 07 11:25:08 at
org.apache.flink.table.planner.runtime.utils.BatchTestBase.check(BatchTestBase.scala:147)
Sep 07 11:25:08 at
org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:162)
Sep 07 11:25:08 at
org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:562)
Sep 07 11:25:08 at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:548)
Sep 07 11:25:08
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
