Bit functions

This topic describes the bit functions that are supported by PolarDB-X.

Bit functions are classified into two types: scalar function and aggregate function.

Scalar functions supported by PolarDB-X

Function Description
| The bitwise OR operator.
\^ The bitwise exclusive OR (XOR) operator.
\& The bitwise AND operator.
BIT_COUNT() Returns the number of 1s in the binary representation of a number.

Aggregate functions supported by PolarDB-X

Function Description
BIT_OR() The bitwise OR operator.
BIT_XOR() The bitwise XOR operator.
BIT_AND() The bitwise AND operator.

Example

The function returns the number of 1s in the binary representation of a number. The function returns NULL if the argument of the function is NULL.

mysql> SELECT BIT_COUNT(29), BIT_COUNT(b'101010');
+--------------+----------------------+
| BIT_COUNT(29) | BIT_COUNT(b'101010') |
+--------------+----------------------+
|            4 |                    3 |
+--------------+----------------------+
1 row in set (0.00 sec)

mysql> SELECT BIT_COUNT(NULL);
+-----------------+
| BIT_COUNT(NULL) |
+-----------------+
|            NULL |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT 3 & 2;
+-------+
| 3 & 2 |
+-------+
|     2 |
+-------+
1 row in set (0.01 sec)

results matching ""

    No results matching ""