oceanbase

1
drop table if exists t2;
2
drop table if exists t3;
3
create table t2 (i int primary key, j int);
4
insert into t2 values (1,1);
5
set autocommit = 1;
6
insert into t2 values (2,2);
7
commit;
8
rollback;
9
select * from t2;
10
i	j
11
1	1
12
2	2
13
set autocommit = 0;
14
insert into t2 values (3,3);
15
rollback;
16
insert into t2 values (3,3);
17
commit;
18
insert into t2 values (3,3);
19
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
20
rollback;
21
commit;
22
set autocommit = 0;
23
insert into t2 values (4,4);
24
create table t3 (i int primary key, j int);
25
select * from t2;
26
i	j
27
1	1
28
2	2
29
3	3
30
4	4
31
rollback;
32
select * from t2;
33
i	j
34
1	1
35
2	2
36
3	3
37
4	4
38
set autocommit = 0;
39
insert into t2 values (5,5);
40
set autocommit = 1;
41
rollback;
42
select * from t2;
43
i	j
44
1	1
45
2	2
46
3	3
47
4	4
48
5	5
49
set autocommit = 0;
50
insert into t2 values (6,6);
51
begin;
52
rollback;
53
select * from t2;
54
i	j
55
1	1
56
2	2
57
3	3
58
4	4
59
5	5
60
6	6
61
drop table if exists t2;
62
drop table if exists t3;
63