[
https://issues.apache.org/jira/browse/SPARK-28109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun resolved SPARK-28109.
-----------------------------------
Resolution: Fixed
Assignee: Yuming Wang
Fix Version/s: 3.0.0
This is resolved via https://github.com/apache/spark/pull/24911
> TRIM(type trimStr FROM str) returns incorrect result
> ----------------------------------------------------
>
> Key: SPARK-28109
> URL: https://issues.apache.org/jira/browse/SPARK-28109
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Yuming Wang
> Assignee: Yuming Wang
> Priority: Major
> Fix For: 3.0.0
>
>
> SPARK-28093 introduced a new bug:
>
> {noformat}
> spark-sql> SELECT trim('yxTomxx', 'xyz'), trim(BOTH 'xyz' FROM 'yxTomxx');
> Tom z
> spark-sql> SELECT trim('xxxbarxxx', 'x'), trim(BOTH 'x' FROM 'xxxbarxxx');
> bar
> spark-sql> SELECT ltrim('zzzytest', 'xyz'), trim(LEADING 'xyz' FROM
> 'zzzytest');
> test xyz
> spark-sql> SELECT ltrim('zzzytestxyz', 'xyz'), trim(LEADING 'xyz' FROM
> 'zzzytestxyz');
> testxyz
> spark-sql> SELECT ltrim('xyxXxyLAST WORD', 'xy'), trim(LEADING 'xy' FROM
> 'xyxXxyLAST WORD');
> XxyLAST WORD
> spark-sql> SELECT rtrim('testxxzx', 'xyz'), trim(TRAILING 'xyz' FROM
> 'testxxzx');
> test xy
> spark-sql> SELECT rtrim('xyztestxxzx', 'xyz'), trim(TRAILING 'xyz' FROM
> 'xyztestxxzx');
> xyztest
> spark-sql> SELECT rtrim('TURNERyxXxy', 'xy'), trim(TRAILING 'xy' FROM
> 'TURNERyxXxy');
> TURNERyxX{noformat}
> {noformat}
> postgres=# SELECT trim('yxTomxx', 'xyz'), trim(BOTH 'xyz' FROM 'yxTomxx');
> btrim | btrim
> -------+-------
> Tom | Tom
> (1 row)
> postgres=# SELECT trim('xxxbarxxx', 'x'), trim(BOTH 'x' FROM 'xxxbarxxx');
> btrim | btrim
> -------+-------
> bar | bar
> (1 row)
> postgres=# SELECT ltrim('zzzytest', 'xyz'), trim(LEADING 'xyz' FROM
> 'zzzytest');
> ltrim | ltrim
> -------+-------
> test | test
> (1 row)
> postgres=# SELECT ltrim('zzzytestxyz', 'xyz'), trim(LEADING 'xyz' FROM
> 'zzzytestxyz');
> ltrim | ltrim
> ---------+---------
> testxyz | testxyz
> (1 row)
> postgres=# SELECT ltrim('xyxXxyLAST WORD', 'xy'), trim(LEADING 'xy' FROM
> 'xyxXxyLAST WORD');
> ltrim | ltrim
> --------------+--------------
> XxyLAST WORD | XxyLAST WORD
> (1 row)
> postgres=# SELECT rtrim('testxxzx', 'xyz'), trim(TRAILING 'xyz' FROM
> 'testxxzx');
> rtrim | rtrim
> -------+-------
> test | test
> (1 row)
> postgres=# SELECT rtrim('xyztestxxzx', 'xyz'), trim(TRAILING 'xyz' FROM
> 'xyztestxxzx');
> rtrim | rtrim
> ---------+---------
> xyztest | xyztest
> (1 row)
> postgres=# SELECT rtrim('TURNERyxXxy', 'xy'), trim(TRAILING 'xy' FROM
> 'TURNERyxXxy');
> rtrim | rtrim
> -----------+-----------
> TURNERyxX | TURNERyxX
> (1 row)
> {noformat}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
