Shaobo Guan created SPARK-55453:
-----------------------------------
Summary: LIKE returns wrong results for emoji
Key: SPARK-55453
URL: https://issues.apache.org/jira/browse/SPARK-55453
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.5.6
Reporter: Shaobo Guan
Expression "LIKE" returns wrong results for when the string contains emojis.
Examples to repro:
LIKE(varchar, varchar) edge cases
Row 125 (inputs=WrappedArray(😀😇🥑, %🥑)):
Column 'out': actual=false, expected=true
Row 127 (inputs=WrappedArray(😀😇🥑, 😀%)):
Column 'out': actual=false, expected=true
Row 128 (inputs=WrappedArray(😀😇🥑, 😀_🥑)):
Column 'out': actual=false, expected=true
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
