[jira] [Created] (FLINK-22015) SQL filter containing OR and IS NULL will produce an incorrect result.

[Shang Yuanchun (Jira)]

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)