Debian Codegraph @

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

raw
1 #
2 # Bug# 20005279 ASSERT !OTHER_LOCK, LOCK_MOVE_REORGANIZE_PAGE()
3 #
4 create table t1 (f1 int auto_increment primary key,
5 f2 char(255)) engine=innodb;
6 start transaction;
7 commit;
8 start transaction;
9 select f1, f2 from t1 where f1 = 20 for update;
10 f1 f2
11 20 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
12 connect con1,localhost,root,,;
13 select f1 from t1 where f1 = 20 for update;
14 connection default;
15 SET @save_dbug = @@debug_dbug;
16 SET DEBUG_DBUG = '+d,do_page_reorganize,do_lock_reverse_page_reorganize';
17 insert into t1(f2) values (repeat('+', 100));
18 SET DEBUG_DBUG = @save_dbug;
19 commit;
20 connection con1;
21 f1
22 20
23 disconnect con1;
24 connection default;
25 drop table t1;
26 #
27 # MDEV-27993 Assertion failed in btr_page_reorganize_low()
28 #
29 CREATE TABLE t1(a INT PRIMARY KEY, b INT UNIQUE) ENGINE=InnoDB;
30 SET DEBUG_DBUG = '+d,do_page_reorganize';
31 INSERT INTO t1 VALUES(0,0);
32 DROP TABLE t1;