[ https://issues.apache.org/jira/browse/SPARK-47440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kent Yao updated SPARK-47440: ----------------------------- Parent: SPARK-47361 Issue Type: Sub-task (was: Bug) > 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: Sub-task > Components: SQL > Affects Versions: 4.0.0 > Reporter: Stefan Bukorovic > Assignee: Stefan Bukorovic > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0, 3.5.2 > > > 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