mirror of
https://github.com/MariaDB/server.git
synced 2025-04-16 12:15:38 +02:00
106 lines
1.5 KiB
Text
106 lines
1.5 KiB
Text
# Establish connection conn1 (user = root)
|
|
connect conn1,localhost,root,,;
|
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
|
|
DROP TABLE IF EXISTS foo;
|
|
connection conn1;
|
|
set session transaction isolation level read committed;
|
|
create table foo ( a int, b int, primary key (a));
|
|
insert into foo values (1,1),(2,2),(3,1),(4,3);
|
|
select * from foo;
|
|
a b
|
|
1 1
|
|
2 2
|
|
3 1
|
|
4 3
|
|
begin;
|
|
update foo set b=10 where b=1;
|
|
select * from foo;
|
|
a b
|
|
1 10
|
|
2 2
|
|
3 10
|
|
4 3
|
|
connection default;
|
|
set session transaction isolation level read committed;
|
|
select * from foo;
|
|
a b
|
|
1 1
|
|
2 2
|
|
3 1
|
|
4 3
|
|
set session transaction isolation level read uncommitted;
|
|
select * from foo;
|
|
a b
|
|
1 10
|
|
2 2
|
|
3 10
|
|
4 3
|
|
connection conn1;
|
|
rollback;
|
|
begin;
|
|
insert into foo values (5,1),(6,2),(7,1),(8,3);
|
|
select * from foo;
|
|
a b
|
|
1 1
|
|
2 2
|
|
3 1
|
|
4 3
|
|
5 1
|
|
6 2
|
|
7 1
|
|
8 3
|
|
connection default;
|
|
set session transaction isolation level read committed;
|
|
select * from foo;
|
|
a b
|
|
1 1
|
|
2 2
|
|
3 1
|
|
4 3
|
|
set session transaction isolation level read uncommitted;
|
|
select * from foo;
|
|
a b
|
|
1 1
|
|
2 2
|
|
3 1
|
|
4 3
|
|
5 1
|
|
6 2
|
|
7 1
|
|
8 3
|
|
connection conn1;
|
|
commit;
|
|
begin;
|
|
delete from foo where b=1;
|
|
select * from foo;
|
|
a b
|
|
2 2
|
|
4 3
|
|
6 2
|
|
8 3
|
|
connection default;
|
|
set session transaction isolation level read committed;
|
|
select * from foo;
|
|
a b
|
|
1 1
|
|
2 2
|
|
3 1
|
|
4 3
|
|
5 1
|
|
6 2
|
|
7 1
|
|
8 3
|
|
set session transaction isolation level read uncommitted;
|
|
select * from foo;
|
|
a b
|
|
2 2
|
|
4 3
|
|
6 2
|
|
8 3
|
|
connection conn1;
|
|
commit;
|
|
connection default;
|
|
disconnect conn1;
|
|
connection default;
|
|
set session transaction isolation level serializable;
|
|
DROP TABLE foo;
|