[
https://issues.apache.org/jira/browse/FLINK-36256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880863#comment-17880863
]
wenhao.yu commented on FLINK-36256:
-----------------------------------
One change I offer, if necessary, is to treat "IS_NULL" separately in the
"RexSimplify.simplifyOrs()" method
> flink sql optimization exception
> ---------------------------------
>
> Key: FLINK-36256
> URL: https://issues.apache.org/jira/browse/FLINK-36256
> Project: Flink
> Issue Type: Bug
> Affects Versions: 1.13.5
> Reporter: wenhao.yu
> Priority: Major
> Attachments: image-2024-09-11-13-55-21-694.png
>
>
> flink sql generates an error when executing the following statement, "insert
> into table select * from a is null or b in ('1', '2')". The exception
> thrown is "NoSuchElementException: next on empty iterator". The cause of
> the exception is that during the optimization tree phase, "is null" and "in"
> are merged, and "is null" is transformed into "search a in null" logic,
> resulting in an error when iterating values from an empty set.
> !image-2024-09-11-13-55-55-975.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
