diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/instant_alter_inject.result')
-rw-r--r-- | mysql-test/suite/innodb/r/instant_alter_inject.result | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/instant_alter_inject.result b/mysql-test/suite/innodb/r/instant_alter_inject.result new file mode 100644 index 00000000..fe175f5b --- /dev/null +++ b/mysql-test/suite/innodb/r/instant_alter_inject.result @@ -0,0 +1,66 @@ +CREATE TABLE t1(a INT PRIMARY KEY, b INT, KEY(b)) ENGINE=InnoDB +ROW_FORMAT=REDUNDANT PARTITION BY KEY() PARTITIONS 3; +INSERT INTO t1 (a) VALUES (1),(2),(3),(4),(5); +SET @saved_dbug= @@SESSION.debug_dbug; +SET DEBUG_DBUG='+d,ib_commit_inplace_fail_2'; +ALTER TABLE t1 ADD COLUMN c CHAR(3) DEFAULT 'lie'; +ERROR HY000: Internal error: Injected error! +SET DEBUG_DBUG= @saved_dbug; +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check status OK +BEGIN; +UPDATE t1 SET b=a+1; +INSERT INTO t1 VALUES (0,1); +ROLLBACK; +SELECT * FROM t1; +a b +1 NULL +2 NULL +3 NULL +4 NULL +5 NULL +ALTER TABLE t1 ADD COLUMN c CHAR(3) DEFAULT 'lie'; +SET DEBUG_DBUG='+d,ib_commit_inplace_fail_1'; +ALTER TABLE t1 ADD COLUMN d INT NOT NULL DEFAULT -42; +ERROR HY000: Internal error: Injected error! +SET DEBUG_DBUG= @saved_dbug; +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check status OK +BEGIN; +DELETE FROM t1; +INSERT INTO t1 VALUES (1,2,'foo'); +ROLLBACK; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` int(11) DEFAULT NULL, + `c` char(3) DEFAULT 'lie', + PRIMARY KEY (`a`), + KEY `b` (`b`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT + PARTITION BY KEY () +PARTITIONS 3 +DROP TABLE t1; +CREATE TABLE t2(a INT, KEY(a)) ENGINE=InnoDB; +INSERT INTO t2 VALUES (1); +SET DEBUG_DBUG='+d,ib_commit_inplace_fail_1'; +ALTER TABLE t2 ADD COLUMN b INT; +ERROR HY000: Internal error: Injected error! +SET DEBUG_DBUG= @saved_dbug; +CHECK TABLE t2; +Table Op Msg_type Msg_text +test.t2 check status OK +BEGIN; +DELETE FROM t2; +INSERT INTO t2 VALUES (1); +ROLLBACK; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `a` int(11) DEFAULT NULL, + KEY `a` (`a`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 +DROP TABLE t2; |