Stefan Bukorovic created SPARK-47440:
----------------------------------------
Summary: SQLServer does not support LIKE operator in binary
comparison
Key: SPARK-47440
URL: https://issues.apache.org/jira/browse/SPARK-47440
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 4.0.0
Reporter: Stefan Bukorovic
When pushing Spark query to MsSqlServer engine we sometimes construct SQL query
that has a LIKE operator as a part of the binary comparison operation, which is
not permitted in SQL Server syntax.
For example a query
{code:java}
SELECT * FROM people WHERE (name LIKE "s%") = 1{code}
will not execute on MsSQLServer.
These queries should be detected and not pushed to execution in MsSqlServer.
--
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
