可用版本: Dev (3.21) | 最新 (3.20) | 3.19 | 3.18 | 3.17

合并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;

反馈

您对此页面有任何反馈吗? 我们很乐意倾听!

The jOOQ Logo