BOOL_AND

bool_and([distinct] expr)

Description

The BOOL_AND function is used to determine whether a set of boolean values (expr) are all true. When all given boolean values are true, the function returns true; otherwise, it returns false. If the distinct keyword is set, the function will only evaluate unique boolean values.

Parameter Description

• expr: The boolean expression to be logically ANDed.

Return Type

Boolean value.

Usage Example

1. Determine if all boolean values are true:

SELECT bool_and(col) FROM VALUES (true), (true), (true) AS tab(col);
+---------------+
| bool_and(col) |
+---------------+
| true          |
+---------------+

2. Cases with null values:

SELECT bool_and(col) FROM VALUES (true), (true), (null) AS tab(col);
+---------------+
| bool_and(col) |
+---------------+
| true          |
+---------------+

3. Use the distinct keyword to determine if all boolean values are true after deduplication:

SELECT bool_and(DISTINCT col) FROM VALUES (true), (true), (true) AS tab(col);
+------------------------+
| bool_and(DISTINCT col) |
+------------------------+
| true                   |
+------------------------+

4. Cases that include false values:

SELECT bool_and(col) FROM VALUES (false), (true), (null) AS tab(col);
+---------------+
| bool_and(col) |
+---------------+
| false         |
+---------------+

5. Only contains one true value and one false value:

SELECT bool_and(col) FROM VALUES (true), (false) AS tab(col);
+---------------+
| bool_and(col) |
+---------------+
| false         |
+---------------+