[jira] [Created] (PHOENIX-1984) Return value of INSTR should be one-based instead of zero-based

[James Taylor (JIRA)]

James Taylor created PHOENIX-1984:
-------------------------------------

             Summary: 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: Bug
            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)