Debian Codegraph @

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

raw
1 CREATE TABLE t1(a INT PRIMARY KEY, b INT, KEY(b)) ENGINE=InnoDB
2 ROW_FORMAT=REDUNDANT PARTITION BY KEY() PARTITIONS 3;
3 INSERT INTO t1 (a) VALUES (1),(2),(3),(4),(5);
4 SET @saved_dbug= @@SESSION.debug_dbug;
5 SET DEBUG_DBUG='+d,ib_commit_inplace_fail_2';
6 ALTER TABLE t1 ADD COLUMN c CHAR(3) DEFAULT 'lie';
7 ERROR HY000: Internal error: Injected error!
8 SET DEBUG_DBUG= @saved_dbug;
9 CHECK TABLE t1;
10 Table Op Msg_type Msg_text
11 test.t1 check status OK
12 BEGIN;
13 UPDATE t1 SET b=a+1;
14 INSERT INTO t1 VALUES (0,1);
15 ROLLBACK;
16 SELECT * FROM t1;
17 a b
18 1 NULL
19 2 NULL
20 3 NULL
21 4 NULL
22 5 NULL
23 ALTER TABLE t1 ADD COLUMN c CHAR(3) DEFAULT 'lie';
24 SET DEBUG_DBUG='+d,ib_commit_inplace_fail_1';
25 ALTER TABLE t1 ADD COLUMN d INT NOT NULL DEFAULT -42;
26 ERROR HY000: Internal error: Injected error!
27 SET DEBUG_DBUG= @saved_dbug;
28 CHECK TABLE t1;
29 Table Op Msg_type Msg_text
30 test.t1 check status OK
31 BEGIN;
32 DELETE FROM t1;
33 INSERT INTO t1 VALUES (1,2,'foo');
34 ROLLBACK;
35 SHOW CREATE TABLE t1;
36 Table Create Table
37 t1 CREATE TABLE `t1` (
38 `a` int(11) NOT NULL,
39 `b` int(11) DEFAULT NULL,
40 `c` char(3) DEFAULT 'lie',
41 PRIMARY KEY (`a`),
42 KEY `b` (`b`)
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=REDUNDANT
44 PARTITION BY KEY ()
45 PARTITIONS 3
46 DROP TABLE t1;
47 CREATE TABLE t2(a INT, KEY(a)) ENGINE=InnoDB;
48 INSERT INTO t2 VALUES (1);
49 SET DEBUG_DBUG='+d,ib_commit_inplace_fail_1';
50 ALTER TABLE t2 ADD COLUMN b INT;
51 ERROR HY000: Internal error: Injected error!
52 SET DEBUG_DBUG= @saved_dbug;
53 CHECK TABLE t2;
54 Table Op Msg_type Msg_text
55 test.t2 check status OK
56 BEGIN;
57 DELETE FROM t2;
58 INSERT INTO t2 VALUES (1);
59 ROLLBACK;
60 SHOW CREATE TABLE t2;
61 Table Create Table
62 t2 CREATE TABLE `t2` (
63 `a` int(11) DEFAULT NULL,
64 KEY `a` (`a`)
65 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
66 DROP TABLE t2;