[jira] [Assigned] (SPARK-36130) UnwrapCastInBinaryComparison fail when in.list contain CheckOverflow expression
[ https://issues.apache.org/jira/browse/SPARK-36130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wenchen Fan reassigned SPARK-36130: --- Assignee: Fu Chen > 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 >Assignee: 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.000), 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
[jira] [Assigned] (SPARK-36130) UnwrapCastInBinaryComparison fail when in.list contain CheckOverflow expression
[ https://issues.apache.org/jira/browse/SPARK-36130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-36130: Assignee: 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 >Assignee: Apache Spark >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.000), 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
[jira] [Assigned] (SPARK-36130) UnwrapCastInBinaryComparison fail when in.list contain CheckOverflow expression
[ 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.000), 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