Debian Codegraph @

mysql-test/suite/maria/transaction.test

raw
1 #
2 # Test that checks transactions and MVCC
3 #
4
5 #
6 # This is a taken from parts.partition_auto_increment_maria. It originally
7 # crashde because con1 could read the first record from t1, which confused
8 # the optimizer.
9 #
10
11 connect(con1, localhost, root,,);
12 connection default;
13 CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (c1))
14 ENGINE = aria;
15 START TRANSACTION;
16 INSERT INTO t1 (c1) VALUES (2);
17 INSERT INTO t1 (c1) VALUES (4);
18 connection con1;
19 START TRANSACTION;
20 # When Aria proparly supports MVCC, the following two queries will not see
21 # any rows
22 select * from t1;
23 select * from t1 where c1=2;
24 disconnect con1;
25 connection default;
26 drop table t1;