Stefan Bukorovic created SPARK-47994:
----------------------------------------

             Summary: SQLServer does not support 1 and 0 as boolean values
                 Key: SPARK-47994
                 URL: https://issues.apache.org/jira/browse/SPARK-47994
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.4.3
            Reporter: Stefan Bukorovic


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. 



--
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

Reply via email to