合并AND谓词
适用于 ✅ 开源版 ✅ 专业版 ✅ 企业版
一个 AND 谓词 结合了共享相同操作数的比较谓词,通常可以合并成一个单独的比较谓词。
使用 Settings.transformPatternsMergeAndComparison
,可以实现以下转换
-- With Settings.transformPatternsMergeAndComparison active, this: SELECT x = a AND x >= a, x = a AND x <= a, x > a AND x < a, x > a AND x != a, x < a AND x != a -- And many more FROM tab; -- ... is transformed into the equivalent expression: SELECT x = a, -- x = a AND x >= a, x = a, -- x = a AND x <= a, x != x, -- x > a AND x < a, x > a, -- x > a AND x != a, x < a -- x < a AND x != a -- And many more FROM tab;
反馈
您对此页面有任何反馈吗? 我们很乐意倾听!