Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Won't Fix
-
3.0.0
-
None
-
None
Description
PostgreSQL:
postgres=# select substr('1234567890', -1, 5); substr -------- 123 (1 row) postgres=# select substr('1234567890', 1, -1); ERROR: negative substring length not allowed
Spark SQL:
spark-sql> select substr('1234567890', -1, 5); 0 spark-sql> select substr('1234567890', 1, -1); spark-sql>