[
https://issues.apache.org/jira/browse/FLINK-22015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kurt Young closed FLINK-22015.
------------------------------
Resolution: Fixed
fixed: a3be1cc5ed55d8d93a56fa22d3f3421ae6b65722
> 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
> Assignee: Caizhi Weng
> Priority: Critical
> Labels: pull-request-available
> 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)
