Debian Codegraph @

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

raw
1 call mtr.add_suppression("InnoDB: Column stat_value in table mysql\\.innodb_index_stats is BIGINT UNSIGNED but should be BIGINT UNSIGNED NOT NULL");
2 call mtr.add_suppression("InnoDB: Fetch of persistent statistics requested for table");
3 CREATE TABLE test_ps_fetch_corrupted
4 (a INT, PRIMARY KEY (a))
5 ENGINE=INNODB STATS_PERSISTENT=1;
6 ANALYZE TABLE test_ps_fetch_corrupted;
7 Table test.test_ps_fetch_corrupted
8 Op analyze
9 Msg_type status
10 Msg_text Engine-independent statistics collected
11 Table test.test_ps_fetch_corrupted
12 Op analyze
13 Msg_type status
14 Msg_text OK
15 SELECT n_rows, clustered_index_size, sum_of_other_index_sizes
16 FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_fetch_corrupted';
17 n_rows 0
18 clustered_index_size 1
19 sum_of_other_index_sizes 0
20 ALTER TABLE mysql.innodb_index_stats MODIFY stat_value BIGINT UNSIGNED NULL;
21 FLUSH TABLE test_ps_fetch_corrupted;
22 SELECT seq_in_index, column_name, cardinality
23 FROM information_schema.statistics WHERE table_name = 'test_ps_fetch_corrupted'
24 ORDER BY index_name, seq_in_index;
25 seq_in_index 1
26 column_name a
27 cardinality 1
28 SELECT table_rows, avg_row_length, max_data_length, index_length
29 FROM information_schema.tables WHERE table_name = 'test_ps_fetch_corrupted';
30 table_rows 0
31 avg_row_length 0
32 max_data_length 0
33 index_length 0
34 ALTER TABLE mysql.innodb_index_stats MODIFY stat_value BIGINT UNSIGNED NOT NULL;
35 FLUSH TABLE test_ps_fetch_corrupted;
36 SELECT seq_in_index, column_name, cardinality
37 FROM information_schema.statistics WHERE table_name = 'test_ps_fetch_corrupted'
38 ORDER BY index_name, seq_in_index;
39 seq_in_index 1
40 column_name a
41 cardinality 1
42 SELECT table_rows, avg_row_length, max_data_length, index_length
43 FROM information_schema.tables WHERE table_name = 'test_ps_fetch_corrupted';
44 table_rows 0
45 avg_row_length 0
46 max_data_length 0
47 index_length 0
48 DROP TABLE test_ps_fetch_corrupted;
49 # restart