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)
