[SPARK-28036] Support negative length at LEFT/RIGHT SQL functions

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 13/Jun/19 10:47
• Updated: 29/Dec/19 11:25
• Resolved: 29/Dec/19 11:25

Description

PostgreSQL:

postgres=# select left('ahoj', -2), right('ahoj', -2);
 left | right 
------+-------
 ah   | oj
(1 row)

Spark SQL:

spark-sql> select left('ahoj', -2), right('ahoj', -2);

spark-sql>

Issue Links

• links to: GitHub Pull Request #25288