Wan Kun created SPARK-41132:
-------------------------------
Summary: Convert LikeAny and NotLikeAny to InSet if no pattern
contains wildcards
Key: SPARK-41132
URL: https://issues.apache.org/jira/browse/SPARK-41132
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.4.0
Reporter: Wan Kun
We can optimize query
{code:sql}
SELECT * FROM tab WHERE trim(addr) LIKE ANY ('5000', '5001', '5002', '5003',
'5004')
{code}
to
{code:sql}
SELECT * FROM tab WHERE trim(addr) IN ('5000', '5001', '5002', '5003', '5004')
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
