Debian Codegraph @

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

raw
1 CREATE TABLE bug12429573 (i INTEGER PRIMARY KEY, j INTEGER, KEY(j))
2 ENGINE=INNODB STATS_PERSISTENT=1;
3 ANALYZE TABLE bug12429573;
4 Table Op Msg_type Msg_text
5 test.bug12429573 analyze status OK
6 SELECT last_update FROM mysql.innodb_index_stats WHERE
7 table_name = 'bug12429573' AND
8 last_update NOT IN
9 (SELECT last_update FROM mysql.innodb_table_stats
10 WHERE table_name = 'bug12429573');
11 last_update
12 ANALYZE TABLE bug12429573;
13 Table Op Msg_type Msg_text
14 test.bug12429573 analyze status OK
15 SELECT last_update FROM mysql.innodb_index_stats WHERE
16 table_name = 'bug12429573' AND
17 last_update NOT IN
18 (SELECT last_update FROM mysql.innodb_table_stats
19 WHERE table_name = 'bug12429573');
20 last_update
21 DROP TABLE bug12429573;