[
https://issues.apache.org/jira/browse/PHOENIX-1984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14549727#comment-14549727
]
ASF GitHub Bot commented on PHOENIX-1984:
-----------------------------------------
GitHub user naveenmadhire opened a pull request:
https://github.com/apache/phoenix/pull/86
PHOENIX-1984
Changes to INSTR string function to have 1 based return type.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/naveenmadhire/phoenix master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/86.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #86
----
commit 3ef45ee8648d8f10fb0c8c980eedd7ad2ec2fedd
Author: NAVEEN MADHIRE <[email protected]>
Date: 2015-05-19T03:14:57Z
PHOENIX-1984
----
> 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)
