Wang Yanlin created CALCITE-3464:
------------------------------------
Summary: RexSimplify simplifies plan having filter with NULL to
empty values
Key: CALCITE-3464
URL: https://issues.apache.org/jira/browse/CALCITE-3464
Project: Calcite
Issue Type: Bug
Reporter: Wang Yanlin
When filter by comparing to null in sql, the plan will get empty result
{code:java}
@Test public void testSimplifyItemEqualNull() {
String query = "select * from sales.customer as t1 where name = NULL";
sql(query)
.withTester(t -> createDynamicTester())
.withRule(ReduceExpressionsRule.FILTER_INSTANCE)
.check();
}
{code}
The plan after optimization is like this
{code:java}
LogicalProject(**=[$1])
LogicalValues(tuples=[[]])
{code}
The optimized plan will get empty result, is this the result we want?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
