base_table_ddl: CREATE TABLE testdb_S.t1_base1_S ( pk INT, col_int_key INT, col_int INT) ; ALTER TABLE testdb_S.t1_base1_S ENGINE = MEMORY | CREATE TABLE testdb_S.t1_base1_N ( pk INT, col_int_key INT, col_int INT) ENGINE = MEMORY ; # INSERT INTO testdb_S.t1_base1_N SELECT 1 , 1 , 1 | ddl: CREATE SCHEMA testdb_S ; SELECT SLEEP( 2 * { $rand_val = $prng->int(0,100) / 100 } ) ; DROP SCHEMA testdb_S | base_table_ddl | INSERT INTO testdb_S.t1_base1_N SELECT 1 , 1 , 1 | CREATE TRIGGER testdb_S.tr1_1_N BEFORE INSERT ON t1_base1_N FOR EACH ROW BEGIN trigger_action ; END; delete: DELETE FROM testdb_S.t1_base1_S WHERE `pk` > _digit LIMIT 1 ; insert: INSERT INTO testdb_S.t1_base1_S ( `pk` , `col_int_key` , `col_int` ) SELECT _digit , _digit , _digit ; query: ddl | START TRANSACTION | LOCK TABLES testdb_S.t1_base1_S AS _letter READ; trigger_action: insert | delete ;