summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/maria/maria-mvcc.test
blob: 8be8e2ea6303356b7d47a5e1b138e452bad08fb4 (plain)
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
#
# Testing insert and select on a table with two threads
# using locking
#

-- source include/have_maria.inc
set global aria_page_checksum=1;

--disable_warnings
drop table if exists t1;
--enable_warnings

connect (con1,localhost,root,,);
connection con1;

create table t1 (i int) engine=aria;
show create table t1;

# versioning is disabled when table is empty, so insert a row
insert into t1 values (0);

lock tables t1 write concurrent;
insert into t1 values (1);
insert into t1 values (2);
/* should see 0, 1 and 2 */
select i from t1;
select count(*) from t1;

connect (con2,localhost,root,,);
connection con2;
/* should see 0 */
select i from t1;
select count(*) from t1;
lock tables t1 write concurrent;
insert into t1 values (3);
insert into t1 values (4);
/* should see 0, 3 and 4 */
select i from t1;
select count(*) from t1;
unlock tables;
lock tables t1 write concurrent;
insert into t1 values (5);
/* should see 0, 3, 4 and 5 */
select i from t1;
select count(*) from t1;

connect (con3,localhost,root,,);
connection con3;
lock tables t1 write concurrent;
/* should see 0, 3, 4 */
select i from t1;
select count(*) from t1;

connection con1;
insert into t1 values (6);
/* Should see 0, 1, 2, 6 */
select i from t1;
select count(*) from t1;
unlock tables;
lock tables t1 write concurrent;
/* Should see 0, 1, 2, 3, 4 and 6 */
select i from t1;
select count(*) from t1;

connection con2;
/* should see 0, 3, 4, 5 */
select i from t1;
select count(*) from t1;
unlock tables;
/* should see 0, 1, 2, 3, 4, 5, 6 */
select i from t1;
select count(*) from t1;

connection con1;
unlock tables;
/* should see 0, 1, 2, 3, 4, 5, 6 */
select i from t1;
select count(*) from t1;

connection con3;
insert into t1 values (7);
/* should see 0, 3, 4, 7 */
select i from t1;
select count(*) from t1;
unlock tables;
/* should see 0, 1, 2, 3, 4, 5, 6, 7 */
select i from t1;
select count(*) from t1;

connection default;
drop table t1;

#
# Test count(*) for not versioned tables
#

CREATE TABLE t1 (fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,    g GEOMETRY NOT NULL,   SPATIAL KEY(g) ) transactional=1 row_format=page engine=aria;

lock tables t1 write concurrent, t1 as t2 write concurrent;
insert into t1 (fid,g) values (NULL,GeomFromText('LineString(0 0,1 1)'));
select fid from t1 as t2;
select count(*) from t1 as t2;
insert into t1 (fid,g) values (NULL,GeomFromText('LineString(0 0,1 1)'));
select fid from t1 as t2;
select count(*) from t1 as t2;
unlock tables;
drop table t1;