[ https://issues.apache.org/jira/browse/SPARK-28451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16890099#comment-16890099 ]
Hyukjin Kwon commented on SPARK-28451: -------------------------------------- Personally I don't think it'w worth but let's see what other committers like. > 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