[FLINK-35476] The IF built-in function returns an exception when returning a string - ASF JIRA

XML

Word

Printable

JSON

The IF built-in function returns an exception when returning a string

There is no explanation in the official documentation！

offlical link：

Flink version：1.15.1/1.15.3

CASE SQL:

select 
        if('asd'='asd', '1234', '12345' )  as expect_1234
        , if('asd'='123', '1234', '12345') as expect_12345
;

Expected Result：

the column expect_1234  value should be '1234'
the column expect_12345 value should be '12345'

Real Returend Result( test in sql-client):

duplicates

FLINK-30559 May get wrong result for `if` expression if it's string data type