[
https://issues.apache.org/jira/browse/CALCITE-815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18004328#comment-18004328
]
ZheHu commented on CALCITE-815:
-------------------------------
I think following Oracle's semantics is an way to go.
For example, upper('')=upper('') should be null in this case, otherwise the
result is true.
However, filter like upper('')='', the empty string literal should also be
treated as NULL, I haven't found a suitable solution for this.
> 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, pull-request-available
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
