Debian Codegraph @

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

raw
1 set names utf8;
2 CREATE TABLE corrupt_bit_test_ā(
3 a INT AUTO_INCREMENT PRIMARY KEY,
4 b CHAR(100),
5 c INT,
6 z INT,
7 INDEX idx(b))
8 ENGINE=InnoDB STATS_PERSISTENT=0;
9 INSERT INTO corrupt_bit_test_ā VALUES(0,'x',1, 1);
10 CREATE UNIQUE INDEX idxā ON corrupt_bit_test_ā(c, b);
11 CREATE UNIQUE INDEX idxē ON corrupt_bit_test_ā(z, b);
12 SELECT * FROM corrupt_bit_test_ā;
13 a b c z
14 1 x 1 1
15 INSERT INTO corrupt_bit_test_ā SELECT 0,b,c+1,z+1 FROM corrupt_bit_test_ā;
16 select count(*) from corrupt_bit_test_ā;
17 count(*)
18 2
19 SET @save_dbug = @@SESSION.debug_dbug;
20 SET debug_dbug = '+d,dict_set_index_corrupted';
21 check table corrupt_bit_test_ā;
22 Table Op Msg_type Msg_text
23 test.corrupt_bit_test_ā check Warning InnoDB: Index idx is marked as corrupted
24 test.corrupt_bit_test_ā check Warning InnoDB: Index idxā is marked as corrupted
25 test.corrupt_bit_test_ā check Warning InnoDB: Index idxē is marked as corrupted
26 test.corrupt_bit_test_ā check error Corrupt
27 SET @@SESSION.debug_dbug = @save_dbug;
28 CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
29 ERROR HY000: Index idx is corrupted
30 CREATE INDEX idx4 ON corrupt_bit_test_ā(b, z);
31 ERROR HY000: Index idx is corrupted
32 select c from corrupt_bit_test_ā;
33 ERROR HY000: Index corrupt_bit_test_ā is corrupted
34 select z from corrupt_bit_test_ā;
35 ERROR HY000: Index corrupt_bit_test_ā is corrupted
36 show warnings;
37 Level Code Message
38 Warning 180 InnoDB: Index idxē for table `test`.`corrupt_bit_test_ā` is marked as corrupted
39 Error 1712 Index corrupt_bit_test_ā is corrupted
40 insert into corrupt_bit_test_ā values (10001, "a", 20001, 20001);
41 select * from corrupt_bit_test_ā use index(primary) where a = 10001;
42 a b c z
43 10001 a 20001 20001
44 begin;
45 insert into corrupt_bit_test_ā values (10002, "a", 20002, 20002);
46 delete from corrupt_bit_test_ā where a = 10001;
47 insert into corrupt_bit_test_ā values (10001, "a", 20001, 20001);
48 rollback;
49 drop index idxā on corrupt_bit_test_ā;
50 check table corrupt_bit_test_ā;
51 Table Op Msg_type Msg_text
52 test.corrupt_bit_test_ā check Warning InnoDB: Index idx is marked as corrupted
53 test.corrupt_bit_test_ā check Warning InnoDB: Index idxē is marked as corrupted
54 test.corrupt_bit_test_ā check error Corrupt
55 set names utf8;
56 select z from corrupt_bit_test_ā;
57 ERROR HY000: Index corrupt_bit_test_ā is corrupted
58 drop index idxē on corrupt_bit_test_ā;
59 CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
60 ERROR HY000: Index idx is corrupted
61 CREATE INDEX idx4 ON corrupt_bit_test_ā(b, z);
62 ERROR HY000: Index idx is corrupted
63 drop index idx on corrupt_bit_test_ā;
64 CREATE INDEX idx3 ON corrupt_bit_test_ā(b, c);
65 CREATE INDEX idx4 ON corrupt_bit_test_ā(b, z);
66 select z from corrupt_bit_test_ā limit 10;
67 z
68 20001
69 1
70 2
71 drop table corrupt_bit_test_ā;