Debian Codegraph @

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

raw
1 CREATE PROCEDURE populate_t1()
2 BEGIN
3 DECLARE i int DEFAULT 1;
4 START TRANSACTION;
5 WHILE (i <= 10000) DO
6 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
7 SET i = i + 1;
8 END WHILE;
9 COMMIT;
10 END|
11 CREATE TABLE t1(
12 class INT,
13 id INT,
14 title VARCHAR(100)
15 ) ENGINE=InnoDB;
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 10000
19 SET SESSION debug="+d,ib_index_build_fail_before_flush";
20 CREATE INDEX idx_id ON t1(id);
21 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
22 CHECK TABLE t1;
23 Table Op Msg_type Msg_text
24 test.t1 check status OK
25 CREATE INDEX idx_title ON t1(title);
26 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
27 CHECK TABLE t1;
28 Table Op Msg_type Msg_text
29 test.t1 check status OK
30 CREATE FULLTEXT INDEX fidx_title ON t1(title);
31 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
32 CHECK TABLE t1;
33 Table Op Msg_type Msg_text
34 test.t1 check status OK
35 ALTER TABLE t1 ADD COLUMN content TEXT, ALGORITHM=INPLACE;
36 ERROR HY000: Got error 1000 - 'InnoDB error' from storage engine
37 CHECK TABLE t1;
38 Table Op Msg_type Msg_text
39 test.t1 check status OK
40 SET SESSION debug="-d,ib_index_build_fail_before_flush";
41 INSERT INTO t1 VALUES(10001, 10001, 'a10000');
42 ALTER TABLE t1 ADD UNIQUE INDEX idx_title(title);
43 ERROR 23000: Duplicate entry 'a10000' for key 't1.idx_title'
44 CHECK TABLE t1;
45 Table Op Msg_type Msg_text
46 test.t1 check status OK
47 ALTER TABLE t1 ADD UNIQUE INDEX idx_id(id), ADD UNIQUE INDEX idx_title(title);
48 ERROR 23000: Duplicate entry 'a10000' for key 't1.idx_title'
49 CHECK TABLE t1;
50 Table Op Msg_type Msg_text
51 test.t1 check status OK
52 DROP TABLE t1;
53 DROP PROCEDURE populate_t1;