Debian Codegraph @

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

raw
1 --source include/have_debug_sync.inc
2 --source include/count_sessions.inc
3
4 --echo #
5 --echo # Bug#25200952 TRANSACTIONS WITH DML WITH SUBQUERIES ON I_S TABLES CAN BLOCK CONCURRENT DDL
6 --echo #
7
8 CREATE TABLE t1 (i INT);
9
10 BEGIN;
11 INSERT INTO t1 (SELECT COUNT(*) FROM information_schema.tables);
12
13 --connect (con1, localhost, root,,)
14 --echo # Connection 1
15 --echo # This create table shouldn't be blocked because of I_S query on mysql.tables in another
16 --echo # connection
17 --send CREATE TABLE t2 (j INT)
18 --reap
19 --disconnect con1
20
21 connection default;
22 commit;
23 DROP TABLE t1;
24 DROP TABLE t2;
25 --source include/wait_until_count_sessions.inc