diff options
Diffstat (limited to 'mysql-test/t/truncate_coverage.test')
| -rw-r--r-- | mysql-test/t/truncate_coverage.test | 40 |
1 files changed, 0 insertions, 40 deletions
diff --git a/mysql-test/t/truncate_coverage.test b/mysql-test/t/truncate_coverage.test index 6f5c773ac6a..0834f7a3eca 100644 --- a/mysql-test/t/truncate_coverage.test +++ b/mysql-test/t/truncate_coverage.test @@ -27,16 +27,12 @@ INSERT INTO t1 VALUES (1); # TRUNCATE shall block on this metadata lock. # We can't use normal DML as such statements would also block LOCK TABLES. # ---echo # ---echo # connection con1 --connect (con1, localhost, root,,) HANDLER t1 OPEN; # # Get connection id of default connection. # Lock the table and start TRUNCATE, which will block on MDL upgrade. # ---echo # ---echo # connection default --connection default let $ID= `SELECT @id := CONNECTION_ID()`; LOCK TABLE t1 WRITE; @@ -47,27 +43,19 @@ send TRUNCATE TABLE t1; # Kill the TRUNCATE query. This shall result in an error return # from wait_while_table_is_used(). # ---echo # ---echo # connection con2 --connect (con2, localhost, root,,) SET DEBUG_SYNC='now WAIT_FOR waiting'; let $invisible_assignment_in_select = `SELECT @id := $ID`; KILL QUERY @id; --disconnect con2 ---echo # ---echo # connection default --connection default --error ER_QUERY_INTERRUPTED reap; UNLOCK TABLES; ---echo # ---echo # connection con1 --connection con1 --echo # Release shared metadata lock by closing HANDLER. HANDLER t1 CLOSE; --disconnect con1 ---echo # ---echo # connection default --connection default DROP TABLE t1; SET DEBUG_SYNC='RESET'; @@ -81,15 +69,11 @@ INSERT INTO t1 VALUES (1); # TRUNCATE shall block on this metadata lock. # We can't use normal DML as such statements would also block LOCK TABLES. # ---echo # ---echo # connection con1 --connect (con1, localhost, root,,) HANDLER t1 OPEN; # # Lock the table and start TRUNCATE, which will block on MDL upgrade. # ---echo # ---echo # connection default --connection default LOCK TABLE t1 WRITE; SET DEBUG_SYNC='mdl_upgrade_lock SIGNAL waiting'; @@ -98,19 +82,13 @@ send TRUNCATE TABLE t1; # Remove datafile. # Commit to let TRUNCATE continue. # ---echo # ---echo # connection con2 --connect (con2, localhost, root,,) SET DEBUG_SYNC='now WAIT_FOR waiting'; --remove_file $MYSQLD_DATADIR/test/t1.frm --disconnect con2 ---echo # ---echo # connection con1 --connection con1 HANDLER t1 CLOSE; --disconnect con1 ---echo # ---echo # connection default --connection default --error ER_NO_SUCH_TABLE reap; @@ -128,8 +106,6 @@ INSERT INTO t1 VALUES (1); # Start a transaction and execute a DML in it. Since 5.4.4 this leaves # a shared meta data lock (MDL) behind. TRUNCATE shall block on it. # ---echo # ---echo # connection con1 --connect (con1, localhost, root,,) START TRANSACTION; INSERT INTO t1 VALUES (2); @@ -137,8 +113,6 @@ INSERT INTO t1 VALUES (2); # Get connection id of default connection. # Start TRUNCATE, which will block on acquire_exclusive_locks(). # ---echo # ---echo # connection default --connection default let $ID= `SELECT @id := CONNECTION_ID()`; SET DEBUG_SYNC='mdl_acquire_lock_wait SIGNAL waiting'; @@ -148,25 +122,17 @@ send TRUNCATE TABLE t1; # Kill the TRUNCATE query. This shall result in an error return # from wait_while_table_is_used(). # ---echo # ---echo # connection con1 --connection con1 SET DEBUG_SYNC='now WAIT_FOR waiting'; let $invisible_assignment_in_select = `SELECT @id := $ID`; KILL QUERY @id; ---echo # ---echo # connection default --connection default --error ER_QUERY_INTERRUPTED reap; ---echo # ---echo # connection con1 --connection con1 --echo # Release SW lock by committing transaction. COMMIT; --disconnect con1 ---echo # ---echo # connection default --connection default UNLOCK TABLES; DROP TABLE t1; @@ -187,19 +153,16 @@ CREATE TABLE t1(a INT) engine=memory; CREATE TABLE m1(a INT) engine=merge UNION(t1); connect(con2, localhost, root); ---echo # Connection con1 connect(con1, localhost, root); SET DEBUG_SYNC= 'open_tables_after_open_and_process_table SIGNAL opened WAIT_FOR dropped'; --echo # Sending: --send TRUNCATE TABLE m1 ---echo # Connection con2 connection con2; SET DEBUG_SYNC= 'now WAIT_FOR opened'; --echo # Sending: --send FLUSH TABLES ---echo # Connection default connection default; --echo # Waiting for FLUSH TABLES to be blocked. let $wait_condition= SELECT COUNT(*)=1 FROM information_schema.processlist @@ -207,7 +170,6 @@ let $wait_condition= SELECT COUNT(*)=1 FROM information_schema.processlist --source include/wait_condition.inc SET DEBUG_SYNC= 'now SIGNAL dropped'; ---echo # Connection con1 connection con1; --echo # Reaping: TRUNCATE TABLE m1 --error ER_WRONG_MRG_TABLE @@ -215,14 +177,12 @@ connection con1; disconnect con1; --source include/wait_until_disconnected.inc ---echo # Connection con2 connection con2; --echo # Reaping: FLUSH TABLES --reap disconnect con2; --source include/wait_until_disconnected.inc ---echo # Connection default connection default; SET DEBUG_SYNC= 'RESET'; DROP TABLE m1, t1; |