[ 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. e.g. 0: jdbc:phoenix:localhost:2181:/hbase>select length(''); -------+ | -------+ null | -------+ row selected (0.006 seconds) : jdbc:phoenix:localhost:2181:/hbase> > 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)