[
https://issues.apache.org/jira/browse/PHOENIX-1984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17749685#comment-17749685
]
ASF GitHub Bot commented on PHOENIX-1984:
-----------------------------------------
stoty closed pull request #86: PHOENIX-1984
URL: https://github.com/apache/phoenix/pull/86
> 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 R. Taylor
> Assignee: Naveen Madhire
> Priority: Major
> Fix For: 4.5.0, 4.4.1
>
>
> 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
(v8.20.10#820010)
