[ 
https://issues.apache.org/jira/browse/PHOENIX-4638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

James Taylor resolved PHOENIX-4638.
-----------------------------------
    Resolution: Not A Bug

Phoenix treats an empty string as null (like Oracle) and the string length of 
null is null.

> string length function returns null for empty string.
> -----------------------------------------------------
>
>                 Key: PHOENIX-4638
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4638
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.13.2-cdh5.11.2
>            Reporter: Clive Stellings
>            Priority: Major
>
> When you execute length('') at the prompt it returns null when it should 
> probably return 0.
> e.g.
> 0: jdbc:phoenix:localhost:2181:/hbase>select length('');
> -------+
>  |       |
> -------+
> | null |
>  -------+
>  row selected (0.006 seconds)
>  : jdbc:phoenix:localhost:2181:/hbase>



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to