[ https://issues.apache.org/jira/browse/SPARK-36130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-36130: ------------------------------------ Assignee: (was: Apache Spark) > 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 > Priority: Major > > 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