Merge OR predicates
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
An OR predicate combining comparison predicates that share the same operands can often be merged into a single comparison predicate.
Using Settings.transformPatternsMergeOrComparison, the following transformations can be achieved:
-- With Settings.transformPatternsMergeOrComparison active, this: SELECT x = a OR x > a, x = a OR x < a, x > a OR x < a, x > a OR x != a, x < a OR x != a -- And many more FROM tab; -- ... is transformed into the equivalent expression: SELECT x >= a, -- x = a OR x > a x <= a, -- x = a OR x < a x != a, -- x > a OR x < a x != a, -- x > a OR x != a x != a -- x < a OR x != a -- And many more FROM tab;
Feedback
Do you have any feedback about this page? We'd love to hear it!