Debian Codegraph @

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

raw
1 CREATE TABLE stats_rename1 (a INT, PRIMARY KEY (a))
2 ENGINE=INNODB STATS_PERSISTENT=1;
3 INSERT INTO mysql.innodb_table_stats
4 SELECT
5 database_name,
6 'stats_rename2' AS table_name,
7 last_update,
8 123 AS n_rows,
9 clustered_index_size,
10 sum_of_other_index_sizes
11 FROM mysql.innodb_table_stats
12 WHERE table_name = 'stats_rename1';
13 INSERT INTO mysql.innodb_index_stats
14 SELECT
15 database_name,
16 'stats_rename2' AS table_name,
17 index_name,
18 last_update,
19 stat_name,
20 567 AS stat_value,
21 sample_size,
22 stat_description
23 FROM mysql.innodb_index_stats
24 WHERE table_name = 'stats_rename1';
25 SELECT table_name, n_rows
26 FROM mysql.innodb_table_stats
27 WHERE table_name IN ('stats_rename1', 'stats_rename2');
28 table_name stats_rename1
29 n_rows 0
30 table_name stats_rename2
31 n_rows 123
32 SELECT table_name, index_name, stat_name, stat_value
33 FROM mysql.innodb_index_stats
34 WHERE table_name IN ('stats_rename1', 'stats_rename2');
35 table_name stats_rename1
36 index_name PRIMARY
37 stat_name n_diff_pfx01
38 stat_value 0
39 table_name stats_rename1
40 index_name PRIMARY
41 stat_name n_leaf_pages
42 stat_value 1
43 table_name stats_rename1
44 index_name PRIMARY
45 stat_name size
46 stat_value 1
47 table_name stats_rename2
48 index_name PRIMARY
49 stat_name n_diff_pfx01
50 stat_value 567
51 table_name stats_rename2
52 index_name PRIMARY
53 stat_name n_leaf_pages
54 stat_value 567
55 table_name stats_rename2
56 index_name PRIMARY
57 stat_name size
58 stat_value 567
59 RENAME TABLE stats_rename1 TO stats_rename2;
60 SELECT table_name, n_rows
61 FROM mysql.innodb_table_stats
62 WHERE table_name IN ('stats_rename1', 'stats_rename2');
63 table_name stats_rename2
64 n_rows 0
65 SELECT table_name, index_name, stat_name, stat_value
66 FROM mysql.innodb_index_stats
67 WHERE table_name IN ('stats_rename1', 'stats_rename2');
68 table_name stats_rename2
69 index_name PRIMARY
70 stat_name n_diff_pfx01
71 stat_value 0
72 table_name stats_rename2
73 index_name PRIMARY
74 stat_name n_leaf_pages
75 stat_value 1
76 table_name stats_rename2
77 index_name PRIMARY
78 stat_name size
79 stat_value 1
80 DROP TABLE stats_rename2;