[
https://issues.apache.org/jira/browse/FLINK-33541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li resolved FLINK-33541.
--------------------------------
Fix Version/s: 1.19.0
1.18.1
1.17.3
Assignee: xuyang
Resolution: Fixed
Fixed via:
master(1.19.0): 45f966e8c3c5e903b3843391874f7d2478122d8c
1.18.1: d60818150005661006a71e4155fc605d7543362b
1.17.3: 58f8162613d9f615e60fb0c9e23692d25469d6f0
Thanks [~xuyangzhong] for the fix and thanks [~dianer17] for reporting the
issue.
> RAND_INTEGER can't be existed in a IF statement
> ------------------------------------------------
>
> Key: FLINK-33541
> URL: https://issues.apache.org/jira/browse/FLINK-33541
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.17.0, 1.18.0
> Reporter: Guojun Li
> Assignee: xuyang
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.19.0, 1.18.1, 1.17.3
>
> Attachments: image-2023-11-24-13-31-21-209.png
>
>
> The minimum produce steps:
> Flink SQL> select if(1=1, rand_integer(100), 0);
> [ERROR] Could not execute SQL statement. Reason:
> java.lang.Exception: Unsupported operand types: IF(boolean, INT, INT NOT NULL)
>
> But we do not see the exception reported in 1.14, not sure which version this
> bug was introduced.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
