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

Clive Stellings updated PHOENIX-4638:
-------------------------------------
    Description: 
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>

  was:When you execute length('') at the prompt it returns null when it should 
probably return 0.


> 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