[jira] [Created] (SPARK-28451) substr returns different values

[Yuming Wang (JIRA)]

Yuming Wang created SPARK-28451:
-----------------------------------

             Summary: 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


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