[ https://issues.apache.org/jira/browse/SPARK-28109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16869079#comment-16869079 ]
Apache Spark commented on SPARK-28109: -------------------------------------- User 'wangyum' has created a pull request for this issue: https://github.com/apache/spark/pull/24908 > 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