You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Yuming Wang (JIRA)" <ji...@apache.org> on 2019/06/18 09:41:00 UTC
[jira] [Created] (SPARK-28093) Built-in function trim/ltrim/rtrim
has bug when using trimStr
Yuming Wang created SPARK-28093:
-----------------------------------
Summary: Built-in function trim/ltrim/rtrim has bug when using trimStr
Key: SPARK-28093
URL: https://issues.apache.org/jira/browse/SPARK-28093
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.0.0
Reporter: Yuming Wang
{noformat}
spark-sql> SELECT trim('yxTomxx', 'xyz'), trim('xxxbarxxx', 'x');
z
spark-sql> SELECT ltrim('zzzytest', 'xyz'), ltrim('xyxXxyLAST WORD', 'xy');
xyz
spark-sql> SELECT rtrim('testxxzx', 'xyz'), rtrim('TURNERyxXxy', 'xy');
xy
spark-sql>
{noformat}
{noformat}
postgres=# SELECT trim('yxTomxx', 'xyz'), trim('xxxbarxxx', 'x');
btrim | btrim
-------+-------
Tom | bar
(1 row)
postgres=# SELECT ltrim('zzzytest', 'xyz'), ltrim('xyxXxyLAST WORD', 'xy');
ltrim | ltrim
-------+--------------
test | XxyLAST WORD
(1 row)
postgres=# SELECT rtrim('testxxzx', 'xyz'), rtrim('TURNERyxXxy', 'xy');
rtrim | rtrim
-------+-----------
test | TURNERyxX
(1 row)
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org