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

ZheHu commented on CALCITE-815:
-------------------------------

[~julianhyde] Before going forward, I want to make sure that I understand the 
above discussion correctly. Here is what I do:
- add SqlConformance#emptyStringIsNull that only ORACLE is enabled
- add one BuiltInMethod that handles empty string to null if emptyStringIsNull 
is true
- splicing this function in String functions that produce empty strings(my 
[dev-branch|https://github.com/ILuffZhe/calcite/commit/48ecd0f76e9ba9bf195913d9f4c789add8ede432]
 takes REPLACE as an example)



> 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)

Reply via email to