or_distributive.sql 337 B

1234567891011121314
  1. pragma config.flags("OptimizerFlags", "ExtractCommonPredicatesFromLogicalOps");
  2. $a = 1 > 2;
  3. $b = 3 < 4;
  4. $c = 5 < 6;
  5. $d = 7 > 8;
  6. $e = 9 < 10;
  7. $f = 11 > 12;
  8. select (($a and $b) or ($b and $c)) == ($b and ($a or $c));
  9. select (($a and $b) or ($d and $e) or ($b and $c) or ($e and $f)) ==
  10. ($b and ($a or $c) or $e and ($d or $f));