Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10

BOOL_OR

Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition

The BOOL_OR() aggregate function calculates the boolean disjunction of all the boolean values in the aggregated group. In other words, this is:

As with most aggregate functions, NULL values are not aggregated, so three valued logic does not apply here.

SELECT
  bool_or(ID >= 4),
  bool_or(ID >= 5)
FROM BOOK

create.select(
         boolOr(BOOK.ID.ge(4)),
         boolOr(BOOK.ID.ge(5)))
      .from(BOOK)

Producing:

+---------+---------+
| bool_or | bool_or |
+---------+---------+
| true    | false   |
+---------+---------+

boolOr(BOOK.ID.ge(4))

Do you have any feedback about this page? We'd love to hear it!

Community