You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Yibo Dong (Jira)" <ji...@apache.org> on 2026/08/26 05:00:00 UTC
[jira] [Created] (SPARK-59019) Excluding RewriteWithExpression causes an INTERNAL_ERROR for a legal BETWEEN query
Yibo Dong created SPARK-59019:
---------------------------------
Summary: Excluding RewriteWithExpression causes an INTERNAL_ERROR for a legal BETWEEN query
Key: SPARK-59019
URL: https://issues.apache.org/jira/browse/SPARK-59019
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 5.0.0
Environment: {{Spark 5.0.0-SNAPSHOT, commit 9da9f8d673914d1648514f59d85e3adafb300d1a; macOS arm64; Java 17.0.17}}
Reporter: Yibo Dong
## What happened
A legal `BETWEEN` query succeeds with `RewriteWithExpression` enabled but fails with a stable internal error when the rule is excluded.
## How to reproduce
Save the following SQL as `repro.sql`:
```sql
SELECT x BETWEEN 1 AND 2 AS in_range
FROM (VALUES (1)) AS t(x);
```
Run it once normally and once with `RewriteWithExpression` excluded:
```bash
spark-sql --master 'local[2]' --conf spark.ui.enabled=false --conf spark.sql.adaptive.enabled=false --conf spark.sql.shuffle.partitions=1 -f repro.sql
spark-sql --master 'local[2]' --conf spark.ui.enabled=false --conf spark.sql.adaptive.enabled=false --conf spark.sql.shuffle.partitions=1 --conf spark.sql.optimizer.excludedRules=org.apache.spark.sql.catalyst.optimizer.RewriteWithExpression -f repro.sql
```
## Expected Result
Both configurations should return the same result.
| Configuration | in_range |
|---|---|
| `RewriteWithExpression` enabled | `true` |
| `RewriteWithExpression` excluded | `true` |
## Actual Result
The enabled configuration returns the row, while excluding the rule causes Spark to fail.
| Configuration | Result |
|---|---|
| `RewriteWithExpression` enabled | `true` |
| `RewriteWithExpression` excluded | Internal error |
The failing run reports:
```text
Spark query failed: An error occurred while calling o41.showString.
: org.apache.spark.SparkException: [INTERNAL_ERROR] Cannot generate code for expression: with(((commonexpressionref(CommonExpressionId(0,false), IntegerType, false) >= 1) AND (commonexpressionref(CommonExpressionId(0,false), IntegerType, false) <= 2)), commonexpressiondef(input[0, int, false], CommonExpressionId(0,false))) SQLSTATE: XX000
at org.apache.spark.SparkException$.internalError(SparkException.scala:104)
at org.apache.spark.SparkException$.internalError(SparkException.scala:108)
```
## Notes
The only changed setting is `spark.sql.optimizer.excludedRules=org.apache.spark.sql.catalyst.optimizer.RewriteWithExpression`.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org