You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (Jira)" <ji...@apache.org> on 2019/10/08 05:43:14 UTC
[jira] [Resolved] (SPARK-20915) lpad/rpad with empty pad string
different from MySQL
[ https://issues.apache.org/jira/browse/SPARK-20915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon resolved SPARK-20915.
----------------------------------
Resolution: Incomplete
> 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
> Priority: Major
> Labels: bulk-closed
>
> {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
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org