[
https://issues.apache.org/jira/browse/FLINK-35476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jianhao.Li updated FLINK-35476:
-------------------------------
Description:
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}
the column expect_1234 value should be '1234'
the column expect_12345 value should be '12345'{code}
Real Returend Result( test in sql-client):
!image-2024-05-28-17-04-59-069.png|width=495,height=337!
was:
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}
the column expect_1234 value should be '1234'
the column expect_12345 value should be '12345'{code}
Real Returend Result( test in sql-client):
!image-2024-05-28-17-04-59-069.png|width=581,height=772!
> 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
> Priority: Critical
> 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}
> the column expect_1234 value should be '1234'
> the column expect_12345 value should be '12345'{code}
>
>
> Real Returend Result( test in sql-client):
> !image-2024-05-28-17-04-59-069.png|width=495,height=337!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
