Debian Codegraph @

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

raw
1 #
2 # Test what happens during RENAME TABLE if there are already rows in the stats
3 # tables for the new table. This cannot happen normally, one have to insert
4 # manually like what we do here.
5 #
6 # The RENAME should succeed and existent rows should be overwritten.
7 #
8
9
10 -- vertical_results
11
12 CREATE TABLE stats_rename1 (a INT, PRIMARY KEY (a))
13 ENGINE=INNODB STATS_PERSISTENT=1;
14
15 INSERT INTO mysql.innodb_table_stats
16 SELECT
17 database_name,
18 'stats_rename2' AS table_name,
19 last_update,
20 123 AS n_rows,
21 clustered_index_size,
22 sum_of_other_index_sizes
23 FROM mysql.innodb_table_stats
24 WHERE table_name = 'stats_rename1';
25
26 INSERT INTO mysql.innodb_index_stats
27 SELECT
28 database_name,
29 'stats_rename2' AS table_name,
30 index_name,
31 last_update,
32 stat_name,
33 567 AS stat_value,
34 sample_size,
35 stat_description
36 FROM mysql.innodb_index_stats
37 WHERE table_name = 'stats_rename1';
38
39 SELECT table_name, n_rows
40 FROM mysql.innodb_table_stats
41 WHERE table_name IN ('stats_rename1', 'stats_rename2');
42
43 SELECT table_name, index_name, stat_name, stat_value
44 FROM mysql.innodb_index_stats
45 WHERE table_name IN ('stats_rename1', 'stats_rename2');
46
47 RENAME TABLE stats_rename1 TO stats_rename2;
48
49 SELECT table_name, n_rows
50 FROM mysql.innodb_table_stats
51 WHERE table_name IN ('stats_rename1', 'stats_rename2');
52
53 SELECT table_name, index_name, stat_name, stat_value
54 FROM mysql.innodb_index_stats
55 WHERE table_name IN ('stats_rename1', 'stats_rename2');
56
57 DROP TABLE stats_rename2;