[ https://issues.apache.org/jira/browse/PHOENIX-1984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gabriel Reid resolved PHOENIX-1984. ----------------------------------- Resolution: Fixed Patch looks good. Pushed to master and 4.x branches, thanks for the quick turnaround on this [~naveenmadhire]. > Return value of INSTR should be one-based instead of zero-based > --------------------------------------------------------------- > > Key: PHOENIX-1984 > URL: https://issues.apache.org/jira/browse/PHOENIX-1984 > Project: Phoenix > Issue Type: Sub-task > Reporter: James Taylor > Assignee: Naveen Madhire > > String functions in SQL are one-based, not zero-based. One should be added to > the return value of the INSTR function as it's returning a zero-based return > value current. > We'll hold off on documenting this built-in until this is corrected. -- This message was sent by Atlassian JIRA (v6.3.4#6332)