[IMPALA-13203] ExprRewriter did not rewrite 'id = 0 OR false' as expected

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 4.3.0, Impala 4.4.0
• Fix Version/s: Impala 4.5.0, Impala 4.4.1
• Component/s: Frontend
• Epic Color: ghx-label-6
• Assignee: Zihao Ye
• Reporter: Zihao Ye
• Created: 09/Jul/24 03:17
• Updated: 15/Aug/24 20:25
• Resolved: 18/Jul/24 06:29

Description

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:

Analyzed query: SELECT * FROM functional.alltypestiny WHERE FALSE OR id = CAST(0
AS INT) 

The issue appears to be that the CompoundPredicate generated by NormalizeExprsRule was not analyzed, causing the SimplifyConditionalsRule to skip the rewrite.

Issue Links

• is caused by: IMPALA-12164 The query fails with "IllegalStateException: Illegal reference to non-materialized slot: tid=x sid=x"
• is related to: IMPALA-13302 Some ExprRewriteRule results are not analyzed, leading to unmaterialized slots from reAnalyze