Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_rename_table_if_exists.result

raw
1 CREATE TABLE stats_rename1 (a INT PRIMARY KEY, b INT UNIQUE)
2 ENGINE=INNODB STATS_PERSISTENT=1;
3 BEGIN;
4 INSERT INTO mysql.innodb_table_stats
5 SELECT
6 database_name,
7 'stats_rename2' AS table_name,
8 last_update,
9 123 AS n_rows,
10 clustered_index_size,
11 sum_of_other_index_sizes
12 FROM mysql.innodb_table_stats
13 WHERE table_name = 'stats_rename1';
14 INSERT INTO mysql.innodb_index_stats
15 SELECT
16 database_name,
17 'stats_rename2' AS table_name,
18 index_name,
19 last_update,
20 stat_name,
21 567 AS stat_value,
22 sample_size,
23 stat_description
24 FROM mysql.innodb_index_stats
25 WHERE table_name = 'stats_rename1';
26 COMMIT;
27 SELECT table_name, n_rows
28 FROM mysql.innodb_table_stats
29 WHERE table_name IN ('stats_rename1', 'stats_rename2');
30 table_name stats_rename1
31 n_rows 0
32 table_name stats_rename2
33 n_rows 123
34 SELECT table_name, index_name, stat_name, stat_value
35 FROM mysql.innodb_index_stats
36 WHERE table_name IN ('stats_rename1', 'stats_rename2');
37 table_name stats_rename1
38 index_name PRIMARY
39 stat_name n_diff_pfx01
40 stat_value 0
41 table_name stats_rename1
42 index_name PRIMARY
43 stat_name n_leaf_pages
44 stat_value 1
45 table_name stats_rename1
46 index_name PRIMARY
47 stat_name size
48 stat_value 1
49 table_name stats_rename1
50 index_name b
51 stat_name n_diff_pfx01
52 stat_value 0
53 table_name stats_rename1
54 index_name b
55 stat_name n_leaf_pages
56 stat_value 1
57 table_name stats_rename1
58 index_name b
59 stat_name size
60 stat_value 1
61 table_name stats_rename2
62 index_name PRIMARY
63 stat_name n_diff_pfx01
64 stat_value 567
65 table_name stats_rename2
66 index_name PRIMARY
67 stat_name n_leaf_pages
68 stat_value 567
69 table_name stats_rename2
70 index_name PRIMARY
71 stat_name size
72 stat_value 567
73 table_name stats_rename2
74 index_name b
75 stat_name n_diff_pfx01
76 stat_value 567
77 table_name stats_rename2
78 index_name b
79 stat_name n_leaf_pages
80 stat_value 567
81 table_name stats_rename2
82 index_name b
83 stat_name size
84 stat_value 567
85 RENAME TABLE stats_rename1 TO stats_rename2;
86 ERROR 23000: Can't write; duplicate key in table 'mysql.innodb_table_stats'
87 BEGIN;
88 DELETE FROM mysql.innodb_table_stats WHERE table_name='stats_rename2';
89 DELETE FROM mysql.innodb_index_stats WHERE table_name='stats_rename2';
90 COMMIT;
91 RENAME TABLE stats_rename1 TO stats_rename2;
92 UPDATE mysql.innodb_index_stats SET index_name='c'
93 WHERE table_name='stats_rename2' AND index_name='PRIMARY';
94 ALTER TABLE stats_rename2 CHANGE b d INT, RENAME INDEX b TO c;
95 ERROR 23000: Can't write; duplicate key in table 'mysql.innodb_index_stats'
96 UPDATE mysql.innodb_index_stats SET index_name='PRIMARY'
97 WHERE table_name='stats_rename2' AND index_name='c';
98 ALTER TABLE stats_rename2 CHANGE b d INT, RENAME INDEX b TO c;
99 SELECT table_name, n_rows
100 FROM mysql.innodb_table_stats
101 WHERE table_name IN ('stats_rename1', 'stats_rename2');
102 table_name stats_rename2
103 n_rows 0
104 SELECT table_name, index_name, stat_name, stat_value
105 FROM mysql.innodb_index_stats
106 WHERE table_name IN ('stats_rename1', 'stats_rename2');
107 table_name stats_rename2
108 index_name PRIMARY
109 stat_name n_diff_pfx01
110 stat_value 0
111 table_name stats_rename2
112 index_name PRIMARY
113 stat_name n_leaf_pages
114 stat_value 1
115 table_name stats_rename2
116 index_name PRIMARY
117 stat_name size
118 stat_value 1
119 table_name stats_rename2
120 index_name c
121 stat_name n_diff_pfx01
122 stat_value 0
123 table_name stats_rename2
124 index_name c
125 stat_name n_leaf_pages
126 stat_value 1
127 table_name stats_rename2
128 index_name c
129 stat_name size
130 stat_value 1
131 DROP TABLE stats_rename2;