[FLINK-33541] RAND_INTEGER can't be existed in a IF statement

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0, 1.18.0
• Fix Version/s: 1.19.0, 1.18.1, 1.17.3
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: xuyang
• Reporter: Guojun Li
• Created: 14/Nov/23 10:45
• Updated: 15/Dec/23 15:24
• Resolved: 15/Dec/23 15:24

Description

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.

Issue Links

• links to: GitHub Pull Request #23779