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)