mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
183 lines
2.6 KiB
Text
183 lines
2.6 KiB
Text
set global aria_page_checksum=1;
|
|
drop table if exists t1;
|
|
connect con1,localhost,root,,;
|
|
connection con1;
|
|
create table t1 (i int) engine=aria;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`i` int(11) DEFAULT NULL
|
|
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
|
|
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;
|
|
i
|
|
0
|
|
1
|
|
2
|
|
select count(*) from t1;
|
|
count(*)
|
|
3
|
|
connect con2,localhost,root,,;
|
|
connection con2;
|
|
/* should see 0 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
select count(*) from t1;
|
|
count(*)
|
|
1
|
|
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;
|
|
i
|
|
0
|
|
3
|
|
4
|
|
select count(*) from t1;
|
|
count(*)
|
|
3
|
|
unlock tables;
|
|
lock tables t1 write concurrent;
|
|
insert into t1 values (5);
|
|
/* should see 0, 3, 4 and 5 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
3
|
|
4
|
|
5
|
|
select count(*) from t1;
|
|
count(*)
|
|
4
|
|
connect con3,localhost,root,,;
|
|
connection con3;
|
|
lock tables t1 write concurrent;
|
|
/* should see 0, 3, 4 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
3
|
|
4
|
|
select count(*) from t1;
|
|
count(*)
|
|
3
|
|
connection con1;
|
|
insert into t1 values (6);
|
|
/* Should see 0, 1, 2, 6 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
1
|
|
2
|
|
6
|
|
select count(*) from t1;
|
|
count(*)
|
|
4
|
|
unlock tables;
|
|
lock tables t1 write concurrent;
|
|
/* Should see 0, 1, 2, 3, 4 and 6 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
1
|
|
2
|
|
3
|
|
4
|
|
6
|
|
select count(*) from t1;
|
|
count(*)
|
|
6
|
|
connection con2;
|
|
/* should see 0, 3, 4, 5 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
3
|
|
4
|
|
5
|
|
select count(*) from t1;
|
|
count(*)
|
|
4
|
|
unlock tables;
|
|
/* should see 0, 1, 2, 3, 4, 5, 6 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
6
|
|
select count(*) from t1;
|
|
count(*)
|
|
7
|
|
connection con1;
|
|
unlock tables;
|
|
/* should see 0, 1, 2, 3, 4, 5, 6 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
6
|
|
select count(*) from t1;
|
|
count(*)
|
|
7
|
|
connection con3;
|
|
insert into t1 values (7);
|
|
/* should see 0, 3, 4, 7 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
3
|
|
4
|
|
7
|
|
select count(*) from t1;
|
|
count(*)
|
|
4
|
|
unlock tables;
|
|
/* should see 0, 1, 2, 3, 4, 5, 6, 7 */
|
|
select i from t1;
|
|
i
|
|
0
|
|
1
|
|
2
|
|
3
|
|
4
|
|
5
|
|
6
|
|
7
|
|
select count(*) from t1;
|
|
count(*)
|
|
8
|
|
connection default;
|
|
drop table t1;
|
|
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;
|
|
fid
|
|
1
|
|
select count(*) from t1 as t2;
|
|
count(*)
|
|
1
|
|
insert into t1 (fid,g) values (NULL,GeomFromText('LineString(0 0,1 1)'));
|
|
select fid from t1 as t2;
|
|
fid
|
|
1
|
|
2
|
|
select count(*) from t1 as t2;
|
|
count(*)
|
|
2
|
|
unlock tables;
|
|
drop table t1;
|