1 --source include/have_innodb.inc
3 # Save the initial number of concurrent sessions
4 --source include/count_sessions.inc
7 DROP TABLE IF EXISTS t1;
10 --echo # Establish connection con1 (user=root)
11 connect (con1,localhost,root,,);
12 --echo # Establish connection con2 (user=root)
13 connect (con2,localhost,root,,);
16 --echo ### - While a consistent snapshot transaction is executed,
17 --echo ### no external inserts should be visible to the transaction.
19 --echo # Switch to connection con1
21 CREATE TABLE t1 (a INT) ENGINE=innodb;
22 START TRANSACTION WITH CONSISTENT SNAPSHOT;
24 --echo # Switch to connection con2
26 INSERT INTO t1 VALUES(1);
28 --echo # Switch to connection con1
30 SELECT * FROM t1; # if consistent snapshot was set as expected, we
35 --echo ### - For any non-consistent snapshot transaction, external
36 --echo ### committed inserts should be visible to the transaction.
39 START TRANSACTION; # Now we omit WITH CONSISTENT SNAPSHOT
41 --echo # Switch to connection con2
43 INSERT INTO t1 VALUES(1);
45 --echo # Switch to connection con1
47 SELECT * FROM t1; # if consistent snapshot was not set, as expected, we
52 --echo ### - Bug#44664: valgrind warning for COMMIT_AND_CHAIN and ROLLBACK_AND_CHAIN
53 --echo ### Chaining a transaction does not retain consistency level.
55 START TRANSACTION WITH CONSISTENT SNAPSHOT;
57 COMMIT WORK AND CHAIN;
59 --echo # Switch to connection con2
61 INSERT INTO t1 VALUES(1);
63 --echo # Switch to connection con1
65 SELECT * FROM t1; # if consistent snapshot was not set, as expected, we
69 --echo # Switch to connection default + close connections con1 and con2
77 # Wait till all disconnects are completed
78 --source include/wait_until_count_sessions.inc