[
https://issues.apache.org/jira/browse/PHOENIX-1984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14554614#comment-14554614
]
Hudson commented on PHOENIX-1984:
---------------------------------
SUCCESS: Integrated in Phoenix-master #760 (See
[https://builds.apache.org/job/Phoenix-master/760/])
PHOENIX-1984 Make INSTR 1-based instead of 0-based (gabrielr: rev
c2fed1dac8305f489939fc18e47cd2c2a6c596d8)
*
phoenix-core/src/main/java/org/apache/phoenix/expression/function/InstrFunction.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/InstrFunctionIT.java
*
phoenix-core/src/test/java/org/apache/phoenix/expression/function/InstrFunctionTest.java
> 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)
