[jira] [Commented] (SPARK-47440) SQLServer does not support LIKE operator in binary comparison

["Stefan Bukorovic (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-47440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17828215#comment-17828215 ] 

Stefan Bukorovic commented on SPARK-47440:
------------------------------------------

I want to work on this issue. 

Opened a PR for same: https://github.com/apache/spark/pull/45564

> 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
>            Priority: Major
>              Labels: pull-request-available
>
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org