Caizhi Weng created FLINK-22015:
-----------------------------------
Summary: SQL filter containing OR and IS NULL will produce an
incorrect result.
Key: FLINK-22015
URL: https://issues.apache.org/jira/browse/FLINK-22015
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Affects Versions: 1.13.0
Reporter: Caizhi Weng
Fix For: 1.13.0
Add the following test case to {{CalcITCase}} to reproduce this bug.
{code:scala}
@Test
def myTest(): Unit = {
checkResult(
"""
|WITH myView AS (SELECT a, CASE
| WHEN a = 1 THEN '1'
| ELSE CAST(NULL AS STRING)
| END AS s
|FROM SmallTable3)
|SELECT a FROM myView WHERE s = '2' OR s IS NULL
|""".stripMargin,
Seq(row(2), row(3)))
}
{code}
However if we remove the {{s = '2'}} the result will be correct.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
