[SPARK-47440] SQLServer does not support LIKE operator in binary comparison

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0, 3.5.2
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Stefan Bukorovic
• Reporter: Stefan Bukorovic
• Created: 18/Mar/24 12:42
• Updated: 26/Apr/24 15:52
• Resolved: 22/Mar/24 10:45

Description

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 

SELECT * FROM people WHERE (name LIKE "s%") = 1

will not execute on MsSQLServer.

These queries should be detected and not pushed to execution in MsSqlServer.

Issue Links

• links to: GitHub Pull Request #45564
• links to: GitHub Pull Request #46236