合并OR谓词
适用于 ✅ 开源版 ✅ 专业版 ✅ 企业版
结合共享相同操作数的比较谓词的OR 谓词通常可以合并为单个比较谓词。
使用Settings.transformPatternsMergeOrComparison
,可以实现以下转换
-- 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;
反馈
您对此页面有任何反馈吗? 我们很乐意听到!