You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Zihao Ye (Jira)" <ji...@apache.org> on 2024/07/09 03:18:00 UTC
[jira] [Created] (IMPALA-13203) ExprRewriter did not rewrite 'id = 0 OR false' as expected
Zihao Ye created IMPALA-13203:
---------------------------------
Summary: ExprRewriter did not rewrite 'id = 0 OR false' as expected
Key: IMPALA-13203
URL: https://issues.apache.org/jira/browse/IMPALA-13203
Project: IMPALA
Issue Type: Bug
Components: fe
Affects Versions: Impala 4.4.0
Reporter: Zihao Ye
The comments in the SimplifyConditionalsRule class mention that 'id = 0 OR false' would be rewritten to 'id = 0', but in reality, it does not perform this rewrite as expected. After executing such SQL, we can see in the text plan that:
{code:sql}
Analyzed query: SELECT * FROM functional.alltypestiny WHERE FALSE OR id = CAST(0
AS INT) {code}
The issue appears to be that the CompoundPredicate generated by NormalizeExprsRule was not analyzed, causing the SimplifyConditionalsRule to skip the rewrite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)