[
https://issues.apache.org/jira/browse/CALCITE-6712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17902075#comment-17902075
]
xiong duan commented on CALCITE-6712:
-------------------------------------
[~julianhyde] I added the test method in CALCITE-6711. However, some functions,
for different reasons, return the non-nullable type when they return a NULL
value. So I added another method to check this
`checkNullValueWithNullableType`. If we can resolve these functions, then we
can use `checkNullValueWithNullableType` to replace `checkNull`.
> FROM_BASE64 and PARSE_URL's return data type should always be nullable
> ----------------------------------------------------------------------
>
> Key: CALCITE-6712
> URL: https://issues.apache.org/jira/browse/CALCITE-6712
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Priority: Major
> Labels: pull-request-available
>
> The return values of these two functions are related to the specific
> parameter value.
> If the parameter is not nullable, then the return type is still nullable
> {code:java}
> from_base64('-1');
> return null
> parse_url('http://calcite.apache.org/path1/p.phpk1=v1&k2=v2#Ref1','QUERY',
> 'k3');
> return null
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
