-- TR1 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; DELETE FROM testdb.gaplock_test WHERE div_id = 2 AND emp_id = 100 AND emp_div = 0; INSERT INTO testdb.gaplock_test (id, emp_div, emp_id, start_date, end_date, div_id, code) VALUES (1, 0, 100, '1909-12-31 15:00:00', '2382-12-31 00:00:00', 2, 'testA'); -- TR2 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; DELETE FROM testdb.gaplock_test WHERE div_id = 2 AND emp_id = 200 AND emp_div = 0;