| 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_ā; |