yql/essentials/tests/sql/suites/optimizers/or_absorption.sql


1
2
3
4
5
6
7
8

pragma config.flags("OptimizerFlags", "ExtractCommonPredicatesFromLogicalOps");

$a = 1 > 2;
$b = 3 < 4;
$c = 5 < 6;

select ($a and $b or $b) == $b;
select ($c and ($b or $a) or $a or $b) == ($a or $b)