and_absorption.sql 229 B

123456789
  1. pragma config.flags("OptimizerFlags", "ExtractCommonPredicatesFromLogicalOps");
  2. $a = 1 > 2;
  3. $b = 3 < 4;
  4. $c = 5 < 6;
  5. $d = 7 > 8;
  6. select (($a or $b) and $a) == $a;
  7. select (($b or $a) and $c and $b and ($d or $c)) == ($c and $b);