Yuming Wang created SPARK-39896:
-----------------------------------
Summary: The structural integrity of the plan is broken after
UnwrapCastInBinaryComparison
Key: SPARK-39896
URL: https://issues.apache.org/jira/browse/SPARK-39896
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.3.0
Reporter: Yuming Wang
{code:scala}
sql("create table t1(a decimal(3, 0)) using parquet")
sql("insert into t1 values(100), (10), (1)")
sql("select * from t1 where a in(100000, 10, 0, 1.00)").show
{code}
{noformat}
After applying rule
org.apache.spark.sql.catalyst.optimizer.UnwrapCastInBinaryComparison in batch
Operator Optimization before Inferring Filters, the structural integrity of the
plan is broken.
java.lang.RuntimeException: After applying rule
org.apache.spark.sql.catalyst.optimizer.UnwrapCastInBinaryComparison in batch
Operator Optimization before Inferring Filters, the structural integrity of the
plan is broken.
at
org.apache.spark.sql.errors.QueryExecutionErrors$.structuralIntegrityIsBrokenAfterApplyingRuleError(QueryExecutionErrors.scala:1325)
at
org.apache.spark.sql.catalyst.rules.RuleExecutor.$anonfun$execute$2(RuleExecutor.scala:229)
{noformat}
--
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
