You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Wenchen Fan (Jira)" <ji...@apache.org> on 2026/05/31 01:04:00 UTC
[jira] [Assigned] (SPARK-53454) Fix AlwaysTrue/AlwaysFalse predicate translation in JDBC connectors
[ https://issues.apache.org/jira/browse/SPARK-53454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan reassigned SPARK-53454:
-----------------------------------
Assignee: Petar Vasiljevic
> Fix AlwaysTrue/AlwaysFalse predicate translation in JDBC connectors
> -------------------------------------------------------------------
>
> Key: SPARK-53454
> URL: https://issues.apache.org/jira/browse/SPARK-53454
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 4.1.0
> Reporter: Petar Vasiljevic
> Assignee: Petar Vasiljevic
> Priority: Major
> Labels: pull-request-available
>
> If AQE changes the plan so that the predicate is AlwaysTrue or AlwaysFalse, generated JDBC SQL query would be 'WHERE 1' or 'WHERE 0'. Some dialects don't support it, so we should change the SQL generation to something any dialect can handle.
> Therefore, I propose translating it to 'WHERE 1=1' or 'WHERE 1=0'
--
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