Debian Codegraph @

mysql-test/suite/innodb/t/lock_release.test

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3
4 --echo #
5 --echo # MDEV-34542 Assertion `lock_trx_has_sys_table_locks(trx) == __null'
6 --echo # failed in void row_mysql_unfreeze_data_dictionary(trx_t*)
7 --echo #
8 --echo #
9 CREATE TABLE t1 (c1 CHAR(1) ,c2 INT) ENGINE=INNODB
10 PARTITION BY LINEAR HASH ((c2)) PARTITIONS 512;
11 CREATE TABLE t2 (a INT) ENGINE=INNODB;
12
13 set @old_table_open_cache= @@table_open_cache;
14 XA START 'a';
15 INSERT INTO mysql.innodb_index_stats SELECT * FROM mysql.innodb_index_stats WHERE table_name='';
16 SET GLOBAL table_open_cache=10;
17 INSERT into t2 (a) VALUES (1);
18 SELECT * FROM t1;
19 XA END 'a';
20 XA PREPARE 'a';
21 # Added sleep to make sure that InnoDB main thread is to remove
22 # the innodb_index_stats from table cache
23 SELECT sleep(3);
24 XA ROLLBACK 'a';
25 DROP TABLE t1, t2;
26 SET GLOBAL table_open_cache=@old_table_open_cache;