[CALCITE-3746] RexSimplify changes the order of IS NOT NULL in And RexNode

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.20.0
• Fix Version/s: 1.27.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: pengzhiwei
• Created: 17/Jan/20 10:58
• Updated: 18/Jun/21 08:43
• Resolved: 27/Oct/20 03:26

Description

The RexSimplify changes the order of IS NOT NULL in And RexNode.The following expression 

a is not null and length(a) > 0

is optimazted to 

length(a) > 0 and a is not null

which will affect the logic short circuit for null-test.

Issue Links

• is related to: CALCITE-2450 RexSimplify: reorder predicates to a canonical form as a part of RexSimplify
• links to: GitHub Pull Request #1765