The calculation is performed with 64-bit (BIGINT) precision.This function returns 0 if there were no matching rows. mysql>mysql> select BIT_OR(1);+-----------+| BIT_OR(1) |+-----------+| 1 |+-----------+1 row in set (0.00 sec)