[
https://issues.apache.org/jira/browse/SPARK-20915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Apache Spark reassigned SPARK-20915:
------------------------------------
Assignee: (was: Apache Spark)
> lpad/rpad with empty pad string different from MySQL
> ----------------------------------------------------
>
> Key: SPARK-20915
> URL: https://issues.apache.org/jira/browse/SPARK-20915
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 2.3.0
> Reporter: Yuming Wang
>
> {noformat:title=MySQL}
> mysql> select lpad('hello', -2, ''), lpad('hello', -1, '') , lpad('hello', 0,
> ''), lpad('hello', 1, ''), lpad('hello', 3, ''), lpad('hello', 5, ''),
> lpad('hello', 6, '') from dual;
> +-----------------------+-----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> | lpad('hello', -2, '') | lpad('hello', -1, '') | lpad('hello', 0, '') |
> lpad('hello', 1, '') | lpad('hello', 3, '') | lpad('hello', 5, '') |
> lpad('hello', 6, '') |
> +-----------------------+-----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> | NULL | NULL | | h
> | hel | hello | NULL
> |
> +-----------------------+-----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> 1 row in set (0.01 sec)
> mysql> select rpad('hello', -2, ''), rpad('hello', -1, '') , rpad('hello', 0,
> ''), rpad('hello', 1, ''), rpad('hello', 3, ''), rpad('hello', 5, ''),
> rpad('hello', 6, '') from dual;
> +-----------------------+-----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> | rpad('hello', -2, '') | rpad('hello', -1, '') | rpad('hello', 0, '') |
> rpad('hello', 1, '') | rpad('hello', 3, '') | rpad('hello', 5, '') |
> rpad('hello', 6, '') |
> +-----------------------+-----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> | NULL | NULL | | h
> | hel | hello | NULL
> |
> +-----------------------+-----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> 1 row in set (0.00 sec)
> {noformat}
> {noformat:title=spark-sql}
> spark-sql> select rpad('hello', -2, ''), rpad('hello', -1, '') ,
> rpad('hello', 0, ''), rpad('hello', 1, ''), rpad('hello', 3, ''),
> rpad('hello', 5, ''), rpad('hello', 6, '');
> h hel hello hello
> spark-sql> select lpad('hello', -2, ''), lpad('hello', -1, '') ,
> lpad('hello', 0, ''), lpad('hello', 1, ''), lpad('hello', 3, ''),
> lpad('hello', 5, ''), lpad('hello', 6, '');
> h hel hello hello
> spark-sql>
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
