MariaDB [test]> create table t1 (a inet6);

Query OK, 0 rows affected (0.120 sec)

MariaDB [test]> insert into t1 values ('f::');

Query OK, 1 row affected (0.020 sec)

MariaDB [test]> select bit_or(a) from t1;

+-----------+

| bit_or(a) |

+-----------+

|         0 |

+-----------+

1 row in set (0.000 sec)

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)