[ https://issues.apache.org/jira/browse/SPARK-28451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16890026#comment-16890026 ]
Shivu Sondur commented on SPARK-28451: -------------------------------------- i will check this issue > substr returns different values > ------------------------------- > > Key: SPARK-28451 > URL: https://issues.apache.org/jira/browse/SPARK-28451 > Project: Spark > Issue Type: Sub-task > Components: Tests > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > PostgreSQL: > {noformat} > postgres=# select substr('1234567890', -1, 5); > substr > -------- > 123 > (1 row) > postgres=# select substr('1234567890', 1, -1); > ERROR: negative substring length not allowed > {noformat} > Spark SQL: > {noformat} > spark-sql> select substr('1234567890', -1, 5); > 0 > spark-sql> select substr('1234567890', 1, -1); > spark-sql> > {noformat} -- This message was sent by Atlassian JIRA (v7.6.14#76016) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org