[jira] [Updated] (SPARK-47440) SQLServer does not support LIKE operator in binary comparison
[ 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
[jira] [Updated] (SPARK-47440) SQLServer does not support LIKE operator in binary comparison
[ https://issues.apache.org/jira/browse/SPARK-47440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated SPARK-47440: --- Labels: pull-request-available (was: ) > 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org