Debian Codegraph @

mysql-test/suite/innodb/t/virtual_stats.test

raw
1
2 #
3 # BUG#22469660 INNODB DOESN'T UPDATE INDEX STATS WHEN ADDING OR DROPPING VIRTUAL COLUMN
4 #
5
6 CREATE TABLE t (
7 a INT,
8 b INT,
9 c INT GENERATED ALWAYS AS(a+b),
10 d INT GENERATED ALWAYS AS(a+b+b),
11 KEY idxa (a),
12 KEY vidxcd (c, d)
13 ) ENGINE=INNODB;
14
15 INSERT INTO t (a,b) VALUES (1, 2);
16
17 SELECT index_name, stat_name, stat_description
18 FROM mysql.innodb_index_stats
19 WHERE database_name = 'test' AND table_name = 't';
20
21 ALTER TABLE t ADD COLUMN e INT GENERATED ALWAYS AS(a+a+b), ADD INDEX idxb (b), ALGORITHM=INPLACE;
22
23 SELECT index_name, stat_name, stat_description
24 FROM mysql.innodb_index_stats
25 WHERE database_name = 'test' AND table_name = 't';
26
27 ALTER TABLE t DROP COLUMN c, DROP INDEX idxa, ALGORITHM=INPLACE;
28
29 SELECT index_name, stat_name, stat_description
30 FROM mysql.innodb_index_stats
31 WHERE database_name = 'test' AND table_name = 't';
32
33 ALTER TABLE t ADD INDEX vidxe (e), ALGORITHM=INPLACE;
34
35 SELECT index_name, stat_name, stat_description
36 FROM mysql.innodb_index_stats
37 WHERE database_name = 'test' AND table_name = 't';
38
39 ALTER TABLE t ADD COLUMN f INT GENERATED ALWAYS AS(a + a), ADD INDEX vidxf (f), ALGORITHM=INPLACE;
40
41 SELECT index_name, stat_name, stat_description
42 FROM mysql.innodb_index_stats
43 WHERE database_name = 'test' AND table_name = 't';
44
45 ALTER TABLE t DROP INDEX vidxcd;
46
47 SELECT index_name, stat_name, stat_description
48 FROM mysql.innodb_index_stats
49 WHERE database_name = 'test' AND table_name = 't';
50
51 DROP TABLE t;