Debian Codegraph @

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

raw
1 SELECT table_name, n_rows
2 FROM mysql.innodb_table_stats
3 WHERE table_name IN ('stats_rename_old', 'stats_rename_new');
4 SELECT table_name, index_name, stat_name, stat_value
5 FROM mysql.innodb_index_stats
6 WHERE table_name IN ('stats_rename_old', 'stats_rename_new');
7 CREATE TABLE stats_rename_old (a INT, PRIMARY KEY (a))
8 ENGINE=INNODB STATS_PERSISTENT=1;
9 SELECT table_name, n_rows
10 FROM mysql.innodb_table_stats
11 WHERE table_name IN ('stats_rename_old', 'stats_rename_new');
12 table_name stats_rename_old
13 n_rows 0
14 SELECT table_name, index_name, stat_name, stat_value
15 FROM mysql.innodb_index_stats
16 WHERE table_name IN ('stats_rename_old', 'stats_rename_new');
17 table_name stats_rename_old
18 index_name PRIMARY
19 stat_name n_diff_pfx01
20 stat_value 0
21 table_name stats_rename_old
22 index_name PRIMARY
23 stat_name n_leaf_pages
24 stat_value 1
25 table_name stats_rename_old
26 index_name PRIMARY
27 stat_name size
28 stat_value 1
29 RENAME TABLE stats_rename_old TO stats_rename_new;
30 SELECT table_name, n_rows
31 FROM mysql.innodb_table_stats
32 WHERE table_name IN ('stats_rename_old', 'stats_rename_new');
33 table_name stats_rename_new
34 n_rows 0
35 SELECT table_name, index_name, stat_name, stat_value
36 FROM mysql.innodb_index_stats
37 WHERE table_name IN ('stats_rename_old', 'stats_rename_new');
38 table_name stats_rename_new
39 index_name PRIMARY
40 stat_name n_diff_pfx01
41 stat_value 0
42 table_name stats_rename_new
43 index_name PRIMARY
44 stat_name n_leaf_pages
45 stat_value 1
46 table_name stats_rename_new
47 index_name PRIMARY
48 stat_name size
49 stat_value 1
50 DROP TABLE stats_rename_new;