wenhao.yu created FLINK-36256:
---------------------------------
Summary: 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
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)
