Fu Chen created SPARK-36130: ------------------------------- Summary: UnwrapCastInBinaryComparison fail when in.list contain CheckOverflow expression Key: SPARK-36130 URL: https://issues.apache.org/jira/browse/SPARK-36130 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 3.2.0 Reporter: Fu Chen
UnwrapCastInBinaryComparison fail with the following case {code:java} CREATE TABLE tbl (d decimal(33, 27)) USING PARQUET SELECT d FROM tbl WHERE d NOT IN (d + 1){code} Here {{in.list}} can be a {{CheckOverflow}} expression: {code:java} cast(d#240 as decimal(34,27)) IN (CheckOverflow((promote_precision(cast(d#240 as decimal(34,27))) + 1.000000000000000000000000000), DecimalType(34,27), true)){code} {{}} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org