Debian Codegraph @

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

raw
1 call mtr.add_suppression("InnoDB: Error: Fetch of persistent statistics requested for table *");
2 CREATE TABLE test_ps_fetch_nonexistent
3 (a INT, PRIMARY KEY (a))
4 ENGINE=INNODB STATS_PERSISTENT=1;
5 ANALYZE TABLE test_ps_fetch_nonexistent;
6 Table test.test_ps_fetch_nonexistent
7 Op analyze
8 Msg_type status
9 Msg_text Engine-independent statistics collected
10 Table test.test_ps_fetch_nonexistent
11 Op analyze
12 Msg_type status
13 Msg_text OK
14 SELECT COUNT(*)
15 FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
16 COUNT(*) 1
17 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_fetch_nonexistent';
18 DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
19 FLUSH TABLE test_ps_fetch_nonexistent;
20 SELECT seq_in_index, column_name, cardinality
21 FROM information_schema.statistics WHERE table_name = 'test_ps_fetch_nonexistent'
22 ORDER BY index_name, seq_in_index;
23 seq_in_index 1
24 column_name a
25 cardinality 1
26 SELECT table_rows, avg_row_length, max_data_length, index_length
27 FROM information_schema.tables WHERE table_name = 'test_ps_fetch_nonexistent';
28 table_rows 0
29 avg_row_length 0
30 max_data_length 0
31 index_length 0
32 DROP TABLE test_ps_fetch_nonexistent;