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 -- source include/have_innodb.inc
10
11 -- vertical_results
12
13 CREATE TABLE stats_rename1 (a INT PRIMARY KEY, b INT UNIQUE)
14 ENGINE=INNODB STATS_PERSISTENT=1;
15
16 BEGIN;
17 INSERT INTO mysql.innodb_table_stats
18 SELECT
19 database_name,
20 'stats_rename2' AS table_name,
21 last_update,
22 123 AS n_rows,
23 clustered_index_size,
24 sum_of_other_index_sizes
25 FROM mysql.innodb_table_stats
26 WHERE table_name = 'stats_rename1';
27
28 INSERT INTO mysql.innodb_index_stats
29 SELECT
30 database_name,
31 'stats_rename2' AS table_name,
32 index_name,
33 last_update,
34 stat_name,
35 567 AS stat_value,
36 sample_size,
37 stat_description
38 FROM mysql.innodb_index_stats
39 WHERE table_name = 'stats_rename1';
40 COMMIT;
41
42 SELECT table_name, n_rows
43 FROM mysql.innodb_table_stats
44 WHERE table_name IN ('stats_rename1', 'stats_rename2');
45
46 SELECT table_name, index_name, stat_name, stat_value
47 FROM mysql.innodb_index_stats
48 WHERE table_name IN ('stats_rename1', 'stats_rename2');
49
50 --error ER_DUP_KEY
51 RENAME TABLE stats_rename1 TO stats_rename2;
52 BEGIN;
53 DELETE FROM mysql.innodb_table_stats WHERE table_name='stats_rename2';
54 DELETE FROM mysql.innodb_index_stats WHERE table_name='stats_rename2';
55 COMMIT;
56 RENAME TABLE stats_rename1 TO stats_rename2;
57
58 UPDATE mysql.innodb_index_stats SET index_name='c'
59 WHERE table_name='stats_rename2' AND index_name='PRIMARY';
60 --error ER_DUP_KEY
61 ALTER TABLE stats_rename2 CHANGE b d INT, RENAME INDEX b TO c;
62 UPDATE mysql.innodb_index_stats SET index_name='PRIMARY'
63 WHERE table_name='stats_rename2' AND index_name='c';
64
65 ALTER TABLE stats_rename2 CHANGE b d INT, RENAME INDEX b TO c;
66
67 SELECT table_name, n_rows
68 FROM mysql.innodb_table_stats
69 WHERE table_name IN ('stats_rename1', 'stats_rename2');
70
71 SELECT table_name, index_name, stat_name, stat_value
72 FROM mysql.innodb_index_stats
73 WHERE table_name IN ('stats_rename1', 'stats_rename2');
74
75 DROP TABLE stats_rename2;