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

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

反馈

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

The jOOQ Logo