[
https://issues.apache.org/jira/browse/SPARK-28451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16890558#comment-16890558
]
Takeshi Yamamuro commented on SPARK-28451:
------------------------------------------
I don't have any standard reference for this behaivour though, +1 for the
Dongjoon opnion; if the standard defines this behaviour explicitly, it might be
worth fixing this.
btw, the current ansi mode we have (spark.sql.parser.ansi.enabled) only affects
the spark parser behaviour now, so we might need another new option for this
kind of behaviour changes to follow the standard.
> 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: [email protected]
For additional commands, e-mail: [email protected]
