[
https://issues.apache.org/jira/browse/CALCITE-815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17914729#comment-17914729
]
Julian Hyde commented on CALCITE-815:
-------------------------------------
[~VAE], if you’re working on this, I would suggest making new functions.
SUBSTRING, for example, returns an empty string if the length is zero, but
under this scheme it would return NULL. The new SUBSTRING function has a
nullable return type even if no arguments are nullable.
At code generation time, rather than modifying each if the Java functions that
implemented the builtin operators, consider splicing in a Java function that
converts empty string to null.
> 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)
