4493d40a-92aa-4162-9dfc-bfc4ec0996e6
/
polardbxengine
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
polardbxengine/mysql-test/suite/xengine/r/transaction.result

937 lines
14 KiB
Plaintext
Raw Permalink Blame History

create table t1 (id int primary key, value int, value2 varchar(100), index(value)) engine=xengine;
insert into t1 values (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),(6,6,6),(8,8,8),(9,9,9),(10,10,10);
begin;
insert into t1 values (11,11,11);
select * from t1 where id=1;
id value value2
1 1 1
select * from t1 where value=1;
id value value2
1 1 1
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
1 1 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 1 1
2 2 2
select * from t1 where value < 3 order by id;
id value value2
1 1 1
2 2 2
select value from t1 where value < 3 order by id;
value
1
2
select * from t1 where value2 < 3 order by id;
id value value2
1 1 1
2 2 2
select * from t1 order by id;
id value value2
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
11 11 11
select value from t1 order by id;
value
1
2
3
4
5
6
8
9
10
11
rollback;
begin;
insert into t1 values (7,7,7);
select * from t1 where id=1;
id value value2
1 1 1
select * from t1 where value=1;
id value value2
1 1 1
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
1 1 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 1 1
2 2 2
select * from t1 where value < 3 order by id;
id value value2
1 1 1
2 2 2
select value from t1 where value < 3 order by id;
value
1
2
select * from t1 where value2 < 3 order by id;
id value value2
1 1 1
2 2 2
select * from t1 order by id;
id value value2
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
7 7 7
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
1
2
3
4
5
6
7
8
9
10
rollback;
begin;
update t1 set value2=100 where id=1;
select * from t1 where id=1;
id value value2
1 1 100
select * from t1 where value=1;
id value value2
1 1 100
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 1 100
2 2 2
select * from t1 where value < 3 order by id;
id value value2
1 1 100
2 2 2
select value from t1 where value < 3 order by id;
value
1
2
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
select * from t1 order by id;
id value value2
1 1 100
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
1
2
3
4
5
6
8
9
10
rollback;
begin;
update t1 set value=100 where id=1;
select * from t1 where id=1;
id value value2
1 100 1
select * from t1 where value=1;
id value value2
select value from t1 where value=1;
value
select * from t1 where value2=1;
id value value2
1 100 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 100 1
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
select value from t1 where value < 3 order by id;
value
2
select * from t1 where value2 < 3 order by id;
id value value2
1 100 1
2 2 2
select * from t1 order by id;
id value value2
1 100 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
100
2
3
4
5
6
8
9
10
rollback;
begin;
update t1 set id=100 where id=1;
select * from t1 where id=1;
id value value2
select * from t1 where value=1;
id value value2
100 1 1
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
100 1 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
100 1 1
select value from t1 where value < 3 order by id;
value
2
1
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
100 1 1
select * from t1 order by id;
id value value2
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
100 1 1
select value from t1 order by id;
value
2
3
4
5
6
8
9
10
1
rollback;
begin;
update t1 set value2=100 where value=1;
select * from t1 where id=1;
id value value2
1 1 100
select * from t1 where value=1;
id value value2
1 1 100
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 1 100
2 2 2
select * from t1 where value < 3 order by id;
id value value2
1 1 100
2 2 2
select value from t1 where value < 3 order by id;
value
1
2
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
select * from t1 order by id;
id value value2
1 1 100
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
1
2
3
4
5
6
8
9
10
rollback;
begin;
update t1 set value=100 where value=1;
select * from t1 where id=1;
id value value2
1 100 1
select * from t1 where value=1;
id value value2
select value from t1 where value=1;
value
select * from t1 where value2=1;
id value value2
1 100 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 100 1
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
select value from t1 where value < 3 order by id;
value
2
select * from t1 where value2 < 3 order by id;
id value value2
1 100 1
2 2 2
select * from t1 order by id;
id value value2
1 100 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
100
2
3
4
5
6
8
9
10
rollback;
begin;
update t1 set id=100 where value=1;
select * from t1 where id=1;
id value value2
select * from t1 where value=1;
id value value2
100 1 1
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
100 1 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
100 1 1
select value from t1 where value < 3 order by id;
value
2
1
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
100 1 1
select * from t1 order by id;
id value value2
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
100 1 1
select value from t1 order by id;
value
2
3
4
5
6
8
9
10
1
rollback;
begin;
update t1 set value2=100 where value2=1;
select * from t1 where id=1;
id value value2
1 1 100
select * from t1 where value=1;
id value value2
1 1 100
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 1 100
2 2 2
select * from t1 where value < 3 order by id;
id value value2
1 1 100
2 2 2
select value from t1 where value < 3 order by id;
value
1
2
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
select * from t1 order by id;
id value value2
1 1 100
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
1
2
3
4
5
6
8
9
10
rollback;
begin;
update t1 set value=100 where value2=1;
select * from t1 where id=1;
id value value2
1 100 1
select * from t1 where value=1;
id value value2
select value from t1 where value=1;
value
select * from t1 where value2=1;
id value value2
1 100 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
1 100 1
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
select value from t1 where value < 3 order by id;
value
2
select * from t1 where value2 < 3 order by id;
id value value2
1 100 1
2 2 2
select * from t1 order by id;
id value value2
1 100 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
100
2
3
4
5
6
8
9
10
rollback;
begin;
update t1 set id=100 where value2=1;
select * from t1 where id=1;
id value value2
select * from t1 where value=1;
id value value2
100 1 1
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
100 1 1
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
100 1 1
select value from t1 where value < 3 order by id;
value
2
1
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
100 1 1
select * from t1 order by id;
id value value2
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
100 1 1
select value from t1 order by id;
value
2
3
4
5
6
8
9
10
1
rollback;
begin;
delete from t1 where id=1;
select * from t1 where id=1;
id value value2
select * from t1 where value=1;
id value value2
select value from t1 where value=1;
value
select * from t1 where value2=1;
id value value2
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
select value from t1 where value < 3 order by id;
value
2
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
select * from t1 order by id;
id value value2
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
2
3
4
5
6
8
9
10
rollback;
begin;
delete from t1 where value=1;
select * from t1 where id=1;
id value value2
select * from t1 where value=1;
id value value2
select value from t1 where value=1;
value
select * from t1 where value2=1;
id value value2
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
select value from t1 where value < 3 order by id;
value
2
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
select * from t1 order by id;
id value value2
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
2
3
4
5
6
8
9
10
rollback;
begin;
delete from t1 where value2=1;
select * from t1 where id=1;
id value value2
select * from t1 where value=1;
id value value2
select value from t1 where value=1;
value
select * from t1 where value2=1;
id value value2
select * from t1 where id=5;
id value value2
5 5 5
select * from t1 where value=5;
id value value2
5 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
5 5 5
select * from t1 where id < 3 order by id;
id value value2
2 2 2
select * from t1 where value < 3 order by id;
id value value2
2 2 2
select value from t1 where value < 3 order by id;
value
2
select * from t1 where value2 < 3 order by id;
id value value2
2 2 2
select * from t1 order by id;
id value value2
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
8 8 8
9 9 9
10 10 10
select value from t1 order by id;
value
2
3
4
5
6
8
9
10
rollback;
begin;
insert into t1 values (11,11,11);
insert into t1 values (12,12,12);
insert into t1 values (13,13,13);
delete from t1 where id=9;
delete from t1 where value=8;
update t1 set id=100 where value2=5;
update t1 set value=103 where value=4;
update t1 set id=115 where id=3;
select * from t1 where id=1;
id value value2
1 1 1
select * from t1 where value=1;
id value value2
1 1 1
select value from t1 where value=1;
value
1
select * from t1 where value2=1;
id value value2
1 1 1
select * from t1 where id=5;
id value value2
select * from t1 where value=5;
id value value2
100 5 5
select value from t1 where value=5;
value
5
select * from t1 where value2=5;
id value value2
100 5 5
select * from t1 where id < 3 order by id;
id value value2
1 1 1
2 2 2
select * from t1 where value < 3 order by id;
id value value2
1 1 1
2 2 2
select value from t1 where value < 3 order by id;
value
1
2
select * from t1 where value2 < 3 order by id;
id value value2
1 1 1
2 2 2
select * from t1 order by id;
id value value2
1 1 1
2 2 2
4 103 4
6 6 6
10 10 10
11 11 11
12 12 12
13 13 13
100 5 5
115 3 3
select value from t1 order by id;
value
1
2
103
6
10
11
12
13
5
3
rollback;
drop table t1;
Reference in New Issue View Git Blame Copy Permalink