# Heavy simplified subtest(uses a trigger) of mix2.inc (aka innodb.test)
#
--source include/have_innodb.inc
SET STORAGE_ENGINE = InnoDB;

--echo # Establish the connection b (user=root)
connect (b,localhost,root,,);

--echo # Switch to connection default (user=root)
connection default;
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1(a INT NOT NULL, b INT, PRIMARY KEY(a));
INSERT INTO t1(a) VALUES (1);
SET AUTOCOMMIT = 0;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;

### Here begins the test sequence
--echo # Switch to connection default (user=root)
connection default;
COMMIT;
SELECT * FROM t1 WHERE a = 1;

--echo # Switch to connection b (user=root)
connection b;
--error ER_LOCK_WAIT_TIMEOUT
DELETE FROM t1;

--echo # Switch to connection default (user=root)
connection default;
SELECT * FROM t1;
COMMIT;

--disable_abort_on_error

### Here begins the slightly modified test sequence
--echo # Switch to connection default (user=root)
connection default;
COMMIT;
SELECT * FROM t1 WHERE a = 1;

--echo # Switch to connection b (user=root)
connection b;
# --error ER_LOCK_WAIT_TIMEOUT
# DELETE FROM t1;
DROP TABLE t1;

--echo # Switch to connection default (user=root)
connection default;
SELECT * FROM t1;
COMMIT;


# Cleanup
--echo # disconnect session b
disconnect b;
# Just to be sure
DROP TABLE t1;