Debian Codegraph @

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

raw
1 set debug_sync='reset';
2 CREATE TABLE t1 (
3 id int(11) NOT NULL auto_increment,
4 ggid varchar(32) binary DEFAULT '' NOT NULL,
5 email varchar(64) DEFAULT '' NOT NULL,
6 passwd varchar(32) binary DEFAULT '' NOT NULL,
7 PRIMARY KEY (id),
8 UNIQUE ggid (ggid)
9 ) ENGINE=innodb;
10 Warnings:
11 Warning 1681 Integer display width is deprecated and will be removed in a future release.
12 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
13 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
14 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
15 insert into t1 (ggid,passwd) values ('test1','xxx');
16 insert into t1 (ggid,passwd) values ('test2','yyy');
17 set debug_sync='row_search_before_mtr_restart_for_extra_clust SIGNAL reached WAIT_FOR continue';
18 select * from t1 where ggid='test2';
19 set debug_sync='now WAIT_FOR reached';
20 update t1 set ggid='test0' where id=2;
21 insert into t1 (ggid,passwd) values ('test2','www');
22 set debug_sync='now SIGNAL continue';
23 id ggid email passwd
24 2 test2 yyy
25 set debug_sync='reset';
26 drop table t1;