BIT_OR()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the bitwise "or" operation across a set of numbers.
USAGE
BIT_OR(number)
Argument Name | Description |
|---|---|
| The number to "or" into the aggregated value |
DETAILS
BIT_OR() is an aggregate function that returns the bitwise "or" of a set of values.
The calculation is done with 64-bit (BIGINT) precision.
A string input value is parsed into an integer, with the digits at the start of the string being significant. If there are no leading digits, it is processed as a 0 value.
A NULL input value is ignored, having no effect on the result.
If no numeric values are in the input set, a 0 is returned.
EXAMPLES
CREATE TABLE bit_and_example (
item VARCHAR(20),
val INT
);
INSERT INTO bit_and_example VALUES
('Foo', 242),
('Bar', 101),
('Baz', 99),
('Foo', 113),
('Bar', 64),
('Baz', 86);
SELECT BIT_OR(val)
FROM bit_and_example;
+-------------+
| BIT_OR(val) |
+-------------+
| 247 |
+-------------+
SELECT item, BIT_OR(val)
FROM bit_and_example
GROUP BY item
ORDER BY item;
+------+-------------+
| item | BIT_OR(val) |
+------+-------------+
| Bar | 101 |
| Baz | 119 |
| Foo | 243 |
+------+-------------+