Debian Codegraph @

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

raw
1 CREATE TABLE test_ps_fetch_nonexistent
2 (a INT, PRIMARY KEY (a))
3 ENGINE=INNODB STATS_PERSISTENT=1;
4 ANALYZE TABLE test_ps_fetch_nonexistent;
5 Table test.test_ps_fetch_nonexistent
6 Op analyze
7 Msg_type status
8 Msg_text OK
9 SELECT COUNT(*)
10 FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
11 COUNT(*) 1
12 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_fetch_nonexistent';
13 DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_nonexistent';
14 FLUSH TABLE test_ps_fetch_nonexistent;
15 SELECT seq_in_index, column_name, cardinality
16 FROM information_schema.statistics WHERE table_name = 'test_ps_fetch_nonexistent'
17 ORDER BY index_name, seq_in_index;
18 SEQ_IN_INDEX 1
19 COLUMN_NAME a
20 CARDINALITY 0
21 SELECT table_rows, avg_row_length, max_data_length, index_length
22 FROM information_schema.tables WHERE table_name = 'test_ps_fetch_nonexistent';
23 TABLE_ROWS 0
24 AVG_ROW_LENGTH 0
25 MAX_DATA_LENGTH 0
26 INDEX_LENGTH 0
27 DROP TABLE test_ps_fetch_nonexistent;