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