Yuming Wang created SPARK-20915:
-----------------------------------
Summary: 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]
