--source include/have_innodb.inc

--disable_warnings
DROP TABLE IF EXISTS bug18828;
--enable_warnings

CREATE TABLE bug18828 (a INT) ENGINE=InnoDB;

--connect (con1,localhost,root,,)
--connect (con2,localhost,root,,)
--connect (con3,localhost,root,,)
--connect (con4,localhost,root,,)
--connect (con5,localhost,root,,)
--connect (con6,localhost,root,,)

--connection con1
BEGIN;
--send INSERT INTO bug18828 VALUES (1)

--connection con2
BEGIN;
--send INSERT INTO bug18828 VALUES (2)

--connection con3
BEGIN;
--send INSERT INTO bug18828 VALUES (3)

--connection con4
BEGIN;
--send INSERT INTO bug18828 VALUES (4)

--connection con5
BEGIN;
--send INSERT INTO bug18828 VALUES (5)

--connection con6
BEGIN;
--send INSERT INTO bug18828 VALUES (6)


--connection con6
--reap
COMMIT;

--connection con5
--reap
COMMIT;

--connection con4
--reap
COMMIT;

--connection con3
--reap
COMMIT;

--connection con2
--reap
COMMIT;

--connection con1
--reap
COMMIT;

--disconnect con6
--disconnect con5
--disconnect con4
--disconnect con3
--disconnect con2
--disconnect con1

--connection default

SELECT * FROM bug18828 ORDER BY a;

DROP TABLE bug18828;