Consider query like
where "r_reason_desc" is a nullable field.
When RexSimplify::simplifyFilterPredicates is called on that conjunction of expressions, expression is not simplified, meaning that redundant "is not null" check is not removed.
In the same time, if query like
is passed to optimizer, redundant "is not null" check is eliminated.