MariaDB [test]> create table t2 (b binary(16));
|
Query OK, 0 rows affected (0.118 sec)
|
|
MariaDB [test]> insert into t2 values ('f::');
|
Query OK, 1 row affected (0.015 sec)
|
|
MariaDB [test]> select bit_or(b) from t2;
|
+-----------+
|
| bit_or(b) |
|
+-----------+
|
| 0 |
|
+-----------+
|
1 row in set, 1 warning (0.000 sec)
|
|
MariaDB [test]> show warnings;
|
+---------+------+----------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------------------------------------------------------------+
|
| Warning | 1292 | Truncated incorrect INTEGER value: 'f::\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00' |
|
+---------+------+----------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|