[
https://issues.apache.org/jira/browse/PHOENIX-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14373094#comment-14373094
]
ASF GitHub Bot commented on PHOENIX-1712:
-----------------------------------------
Github user naveenmadhire commented on the pull request:
https://github.com/apache/phoenix/pull/47#issuecomment-84472511
@gabrielreid I wrote the required test cases in InstrFunctionIT.java. All
ASC test cases are working fine. But for DESC I am getting inverted value as
output. For expected value 5 the select statement is giving -6. I confirmed
that INSTR function is returning the correct value both for DESC and ASC
however the output of select is returning different values for DESC. Is there
anything else which I need to handle for DESC scenarios.
Interestingly, all the testcases of InstrFunctionTest are working fine.
> Implementing INSTR function
> ---------------------------
>
> Key: PHOENIX-1712
> URL: https://issues.apache.org/jira/browse/PHOENIX-1712
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Naveen Madhire
> Assignee: Naveen Madhire
> Priority: Minor
> Original Estimate: 40h
> Remaining Estimate: 40h
>
> This is sub-task to implement a custom INSTR function just like in Oracle.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
