Debian Codegraph @

mysql-test/suite/innodb/t/innodb_corrupt_bit.test

raw
1 #
2 # Test for persistent corrupt bit for corrupted index and table
3 #
4 -- source include/have_innodb.inc
5 --source include/not_embedded.inc
6 # This test needs debug server
7 -- source include/have_debug.inc
8
9 --disable_query_log
10 call mtr.add_suppression("Flagged corruption of.* in table .* in .*");
11 --enable_query_log
12
13 set names utf8;
14
15 CREATE TABLE corrupt_bit_test_ā(
16 a INT AUTO_INCREMENT PRIMARY KEY,
17 b CHAR(100),
18 c INT,
19 z INT,
20 INDEX idx(b))
21 ENGINE=InnoDB STATS_PERSISTENT=0;
22
23 INSERT INTO corrupt_bit_test_ā VALUES(0,'x',1, 1);
24
25 CREATE UNIQUE INDEX idxā ON corrupt_bit_test_ā(c, b);
26
27 CREATE UNIQUE INDEX idxē ON corrupt_bit_test_ā(z, b);
28
29 SELECT * FROM corrupt_bit_test_ā;
30
31 INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+1,z+1 FROM corrupt_bit_test_ā;
32
33 select count(*) from corrupt_bit_test_ā;
34
35 # This will flag all secondary indexes corrupted
36 SET @save_dbug = @@SESSION.debug_dbug;
37 SET debug_dbug = '+d,dict_set_index_corrupted';
38 check table corrupt_bit_test_ā;
39 SET @@SESSION.debug_dbug = @save_dbug;
40
41 # Cannot create new indexes while corrupted indexes exist
42 --error ER_INDEX_CORRUPT
43 CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
44 --error ER_INDEX_CORRUPT
45 CREATE INDEX idx4 ON corrupt_bit_test_ā(b, z);
46
47 # This selection intend to use the corrupted index. Expect to fail
48 -- error ER_INDEX_CORRUPT
49 select c from corrupt_bit_test_ā;
50
51 -- error ER_INDEX_CORRUPT
52 select z from corrupt_bit_test_ā;
53
54 show warnings;
55
56 # Since corrupted index is a secondary index, we only disable such
57 # index and allow other DML to proceed
58 insert into corrupt_bit_test_ā values (10001, "a", 20001, 20001);
59
60 # This does not use the corrupted index, expect to succeed
61 select * from corrupt_bit_test_ā use index(primary) where a = 10001;
62
63 # Some more DMLs
64 begin;
65 insert into corrupt_bit_test_ā values (10002, "a", 20002, 20002);
66 delete from corrupt_bit_test_ā where a = 10001;
67 insert into corrupt_bit_test_ā values (10001, "a", 20001, 20001);
68 rollback;
69
70 drop index idxā on corrupt_bit_test_ā;
71
72 check table corrupt_bit_test_ā;
73
74 set names utf8;
75
76 -- error ER_INDEX_CORRUPT
77 select z from corrupt_bit_test_ā;
78
79 # Drop the corrupted index
80 drop index idxē on corrupt_bit_test_ā;
81
82 # Cannot create new indexes while a corrupt index exists.
83 --error ER_INDEX_CORRUPT
84 CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
85 --error ER_INDEX_CORRUPT
86 CREATE INDEX idx4 ON corrupt_bit_test_ā(b, z);
87
88 drop index idx on corrupt_bit_test_ā;
89
90 # Now that there exist no corrupted indexes, we can create new indexes.
91 CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
92 CREATE INDEX idx4 ON corrupt_bit_test_ā(b, z);
93
94
95 # Now select back to normal
96 select z from corrupt_bit_test_ā limit 10;
97
98 # Drop table
99 drop table corrupt_bit_test_ā;