~posulliv/drizzle/optimizer-style-cleanup

connect (con1,localhost,root,,);

connect (con2,localhost,root,,);

connection con1;

CREATE TABLE t1 (a int primary key);

connection con2;

START TRANSACTION WITH CONSISTENT SNAPSHOT;

SELECT count(*) from t1;

connection con1;

BEGIN;

INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10), (11),(12),(13),(14),(15),(16),(17),(18),(19),(20), (21),(22),(23),(24),(25),(26),(27),(28),(29),(30), (31),(32);

connection con2;

select count(*) from t1;

connection con1;

INSERT INTO t1 VALUES  (33),(34),(35),(36),(37),(38),(39),(40),(41),(42);

COMMIT;

SELECT count(*) from t1;

disconnect con1;

disconnect con2;

connection default;

DROP TABLE t1;