MariaDB [test]> CREATE TABLE t1 (i INT, vc TINYINT AS (i) VIRTUAL, INDEX(vc));
|
Query OK, 0 rows affected (0.63 sec)
|
|
MariaDB [test]> INSERT INTO t1 (i) VALUES (1000);
|
Query OK, 1 row affected, 1 warning (0.08 sec)
|
|
MariaDB [test]> SHOW WARNINGS;
|
+---------+------+---------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------------+
|
| Warning | 1264 | Out of range value for column 'vc' at row 1 |
|
+---------+------+---------------------------------------------+
|
1 row in set (0.00 sec)
|