oceanbase

1
set ob_enable_index_direct_select=1;
2
alter system set merger_check_interval = '10s' tenant sys;
3
alter system set merger_check_interval = '10s' tenant all_user;
4
alter system set merger_check_interval = '10s' tenant all_meta;
5
drop table if exists t1;
6
create table t1(pk int primary key, c1 int);
7
create index idx on t1(c1);
8
insert into t1 values(6,6),(7,7),(8,8);
9
set autocommit=0;
10
set autocommit=0;
11
insert into t1 values(1,1);
12
insert into t1 values(1,11);
13
commit;
14
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
15
commit;
16
select * from t1;
17
pk	c1
18
1	1
19
6	6
20
7	7
21
8	8
22
insert into t1 values(2,2);
23
replace into t1 values(2,12);
24
commit;
25
commit;
26
select * from t1;
27
pk	c1
28
1	1
29
2	12
30
6	6
31
7	7
32
8	8
33
replace into t1 values(3,3);
34
insert into t1 values(3,13);
35
commit;
36
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
37
commit;
38
select * from t1;
39
pk	c1
40
1	1
41
2	12
42
3	3
43
6	6
44
7	7
45
8	8
46
replace into t1 values(4,4);
47
replace into t1 values(4,14);
48
commit;
49
commit;
50
select * from t1;
51
pk	c1
52
1	1
53
2	12
54
3	3
55
4	14
56
6	6
57
7	7
58
8	8
59
drop table t1;
60