jianhao.Li created FLINK-35476: ---------------------------------- Summary: The IF built-in function returns an exception when returning a string Key: FLINK-35476 URL: https://issues.apache.org/jira/browse/FLINK-35476 Project: Flink Issue Type: Bug Components: Table SQL / API, Table SQL / Runtime Affects Versions: 1.15.3 Reporter: jianhao.Li Attachments: image-2024-05-28-17-04-59-069.png
The IF built-in function returns an exception when returning a string There is no explanation in the official documentation! offlical link: https://nightlies.apache.org/flink/flink-docs-release-1.15/docs/dev/table/functions/systemfunctions/ Flink version:1.15.1/1.15.3 CASE SQL: {code:java} select if('asd'='asd', '1234', '12345' ) as expect_1234 , if('asd'='123', '1234', '12345') as expect_12345 ; {code} Expected Result: {code:java} expect_1234 value is 1234 expect_12345 value is 12345{code} Real Returend Result( test in sql-client): !image-2024-05-28-17-04-59-069.png! -- This message was sent by Atlassian Jira (v8.20.10#820010)