Petar Vasiljevic created SPARK-53454:
----------------------------------------
Summary: 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
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
