[ 
https://issues.apache.org/jira/browse/SPARK-22576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16261313#comment-16261313
 ] 

Yuxin Cao commented on SPARK-22576:
-----------------------------------

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1600/doc/html/san1278453073929.html

The character position at which to begin the search in the string. The first 
character is position 1. If the starting offset is negative, LOCATE returns the 
last matching string offset, rather than the first. A negative offset indicates 
how much of the end of the string to exclude from the search. The number of 
bytes excluded is calculated as ( -1 * offset ) - 1.

> Spark SQL locate returns incorrect value when the start position is negative
> ----------------------------------------------------------------------------
>
>                 Key: SPARK-22576
>                 URL: https://issues.apache.org/jira/browse/SPARK-22576
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.0.0
>            Reporter: Yuxin Cao
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to