Debian Codegraph @

mysql-test/suite/gcol/t/innodb_virtual_stats.test

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