[
https://issues.apache.org/jira/browse/CALCITE-815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17986420#comment-17986420
]
Julian Hyde commented on CALCITE-815:
-------------------------------------
Functions that consume strings are also affected - whether their return type is
nullable, and the result they compute. CHAR_LENGTH is no longer nullable if is
argument is nullable, because when passed null, it returns zero. SUBSTRING is
nullable even if none of its arguments are, because length may evaluate to
zero.
Changing nullability affects whether functions can be pushed into outer joins,
etc.
> Add an option to allow empty strings to represent null values
> -------------------------------------------------------------
>
> Key: CALCITE-815
> URL: https://issues.apache.org/jira/browse/CALCITE-815
> Project: Calcite
> Issue Type: New Feature
> Reporter: Wei Xue
> Assignee: ZheHu
> Priority: Major
> Labels: dialect, phoenix
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
