[SPARK-47994] SQLServer does not support 1 and 0 as boolean values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.3
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Stefan Bukorovic
• Reporter: Stefan Bukorovic
• Created: 25/Apr/24 15:48
• Updated: 29/Apr/24 11:42
• Resolved: 29/Apr/24 11:42

Description

Sometimes in Spark, when a column that is generated as CASE WHEN structure is used in comparison filter, output of optimized plan will be: CASE WHEN expression THEN (1 or 0)... which is not supported in SQLServer. Exception is thrown by SQLServer that a "non-boolean expression is given when boolean was expected". For now, we should not support CASE WHEN pushdown in SQLServer. 

Issue Links

• links to: GitHub Pull Request #46231