Collapse the sub-tree of plan that always returns empty set

[leiysky]

Replace the sub-tree of plan that always returns 0 rows with a EmptySet operator, for example the following query can be optimized with this approach:

select * from t where FALSE;

[FANNG1]

select * from t where a > 1 and a < 1;
could be optimized?

[leiysky]

select * from t where a > 1 and a < 1; could be optimized?

Sure. And it's possible to optimize with real data distribution.