oceanbase

1
drop table if exists t;
2
create table t (c1 int primary key, c2 int);
3
insert into t values(1,2),(3,4),(1,2);
4
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
5
insert into t values(1,2),(3,4),(5,6);
6
select * from t;
7
c1	c2
8
1	2
9
3	4
10
5	6
11
select * from t where c1 in (1,3,1);
12
c1	c2
13
1	2
14
3	4
15
select * from t where c1 in (1,1);
16
c1	c2
17
1	2
18
drop table t;
19