MariaDB [test]> create or replace table t1 (a inet6 not null) engine=csv;
|
Query OK, 0 rows affected (0.062 sec)
|
|
MariaDB [test]> insert into t1 values ('2001:db8::ff00:42:8329');
|
Query OK, 1 row affected (0.017 sec)
|
|
MariaDB [test]> select * from t1;
|
ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired
|
MariaDB [test]> repair table t1;
|
+---------+--------+----------+-------------------------------------------------------------------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+---------+--------+----------+-------------------------------------------------------------------------------------+
|
| test.t1 | repair | Warning | Incorrect inet6 value: '2001:db8::ff00:42:8329' for column `test`.`t1`.`a` at row 1 |
|
| test.t1 | repair | status | OK |
|
+---------+--------+----------+-------------------------------------------------------------------------------------+
|
2 rows in set (0.017 sec)
|
|
MariaDB [test]> select * from t1;
|
Empty set (0.001 sec)
|