consistent_snapshot.result 553 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10
DROP TABLE IF EXISTS t1;
# Establish connection con1 (user=root)
# Establish connection con2 (user=root)
# Switch to connection con1
CREATE TABLE t1 (a INT) ENGINE=innodb;
START TRANSACTION WITH CONSISTENT SNAPSHOT;
# Switch to connection con2
INSERT INTO t1 VALUES(1);
# Switch to connection con1
SELECT * FROM t1;
11
a
12 13 14 15 16 17 18
COMMIT;
DELETE FROM t1;
START TRANSACTION;
# Switch to connection con2
INSERT INTO t1 VALUES(1);
# Switch to connection con1
SELECT * FROM t1;
19 20
a
1
21 22 23
COMMIT;
# Switch to connection default + close connections con1 and con2
DROP TABLE t1;