[
https://issues.apache.org/jira/browse/FLINK-32497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17823451#comment-17823451
]
Han Zhuo commented on FLINK-32497:
----------------------------------
Thanks, I have closed this issue.
> IF FUNCTION is FALSE and the false_value parameter is a function, then an
> exception will be thrown
> --------------------------------------------------------------------------------------------------
>
> Key: FLINK-32497
> URL: https://issues.apache.org/jira/browse/FLINK-32497
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API, Table SQL / Client
> Affects Versions: 1.17.1
> Environment: {color:#172b4d}----- Flink Version -----{color}
> {color:#172b4d}V{color}{color:#172b4d}ersion: 1.17.1, Commit ID:
> 2750d5c{color}
>
> {color:#172b4d}----- Java Version -----{color}
> {color:#172b4d}java version "1.8.0_202"{color}
> {color:#172b4d}Java(TM) SE Runtime Environment (build 1.8.0_202-b08){color}
> {color:#172b4d}Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed
> mode){color}
>
> Reporter: Han Zhuo
> Priority: Critical
> Fix For: 1.16.3, 1.17.2
>
> Attachments: flink-1.17.1_logs_jarieshan_20230630.tgz,
> image-2023-06-30-15-02-13-197.png, image-2023-06-30-15-02-26-099.png,
> image-2023-06-30-15-02-57-082.png, image-2023-06-30-15-07-08-588.png,
> image-2023-06-30-15-09-44-623.png, image-2023-06-30-15-10-08-619.png,
> image-2023-06-30-15-13-56-625.png, image-2023-06-30-15-14-21-038.png
>
>
> It is successful to execute certain functions individually.
> {code:java}
> SELECT SPLIT_INDEX('TEST:ABC', ':', 0); {code}
> !image-2023-06-30-15-02-57-082.png|width=189,height=36!
>
> And it is also successful for these functions to be located in the true_value
> parameter of the {color:#172b4d}+IF function+{color}.
> {code:java}
> SELECT IF(2>1, SPLIT_INDEX('TEST:ABC', ':', 1), 'FALSE'); {code}
> !image-2023-06-30-15-02-13-197.png|width=185,height=36!
>
> Only when these functions are located in the false_value parameter of the
> {+}IF function{+}, an exception will be thrown.
> func1.
> {code:java}
> SELECT IF(2>1, 'TRUE', SPLIT_INDEX('TEST:ABC', ':', 0)); {code}
> {color:#172b4d}!image-2023-06-30-15-09-44-623.png|width=385,height=42!{color}
> func2.
> {code:java}
> SELECT IF(2>1, 'TRUE', LOWER('TEST')); {code}
> !image-2023-06-30-15-14-21-038.png|width=337,height=246!
>
> {color:#172b4d}And it is also successful for{color} +CASE function+
> {code:java}
> SELECT CASE WHEN 2=1 THEN 'TRUE' ELSE SPLIT_INDEX('TEST:ABC', ':', 0) END;
> {code}
> {color:#172b4d}!image-2023-06-30-15-10-08-619.png|width=188,height=41!{color}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
