Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2(EOL)
-
None
Description
No index, no warning |
MariaDB [test]> CREATE TABLE t1 (i INT, vc TINYINT AS (i) VIRTUAL); |
Query OK, 0 rows affected (0.54 sec) |
|
MariaDB [test]> INSERT INTO t1 (i) VALUES (1000); |
Query OK, 1 row affected (0.07 sec)
|
Warning with index |
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) |
Attachments
Issue Links
- relates to
-
MDEV-5800 indexes on virtual (not materialized) columns
- Closed