[jira] [Commented] (FLINK-30221) Fix the bug of sum(try_cast(string as bigint)) return null when partial elements can't convert to bigint

[Martijn Visser (Jira)]

    [ 
https://issues.apache.org/jira/browse/FLINK-30221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641291#comment-17641291
 ] 

Martijn Visser commented on FLINK-30221:
----------------------------------------

[~lsy] No, the result should not be 12 from your example. From the 
documentation example it even states {{TRY_CAST(’non-number’ AS INT) returns 
NULL}}. This is intended behaviour. Any failure in a TRY_CAST should result in 
the returning of a NULL value. 

> Fix the bug of sum(try_cast(string as bigint)) return null when partial 
> elements can't convert to bigint
> --------------------------------------------------------------------------------------------------------
>
>                 Key: FLINK-30221
>                 URL: https://issues.apache.org/jira/browse/FLINK-30221
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API, Table SQL / Runtime
>    Affects Versions: 1.17.0
>            Reporter: dalongliu
>            Priority: Major
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)