You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (JIRA)" <ji...@apache.org> on 2019/06/19 16:11:00 UTC
[jira] [Assigned] (SPARK-28109) TRIM(type trimStr FROM str) returns
incorrect result
[ https://issues.apache.org/jira/browse/SPARK-28109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-28109:
------------------------------------
Assignee: Apache Spark
> 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: Apache Spark
> Priority: Major
>
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org