-- USE `test`;
-- SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
-- SELECT @@tx_isolation;
-- SELECT * FROM `test_table`;

-- deadlock test ----------

-- session 1 -------------
USE `test`;
SET autocommit = 0;
COMMIT;
SHOW ENGINE INNODB STATUS;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
call READ_PROCEDURE();
SHOW ENGINE INNODB STATUS;
-- end session 1 -------------

-- session 2 ------------
USE `test`;
SET autocommit = 0;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
UPDATE `test_table` SET `test_table`.`strTextExtended` = 'UPDATED';
SHOW ENGINE INNODB STATUS;
-- end session 2 ------------