Debian Codegraph @

mysql-test/suite/storage_engine/trx/cons_snapshot_repeatable_read.result

raw
1 DROP TABLE IF EXISTS t1;
2 connect con1,localhost,root,,;
3 connect con2,localhost,root,,;
4 connection con1;
5 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
6 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
7 START TRANSACTION WITH CONSISTENT SNAPSHOT;
8 connection con2;
9 INSERT INTO t1 (a) VALUES (1);
10 connection con1;
11 # If consistent read works on this isolation level (REPEATABLE READ), the following SELECT should not return the value we inserted (1)
12 SELECT a FROM t1;
13 a
14 COMMIT;
15 connection default;
16 disconnect con1;
17 disconnect con2;
18 DROP TABLE t1;