oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: rkaizhan.dkz
5
#owner group: sql1
6
#tags: dml
7
#description:
8

9
--disable_warnings
10
drop table if exists t;
11
--enable_warnings
12
create table t (c1 int primary key, c2 int);
13

14
--error 1062
15
insert into t values(1,2),(3,4),(1,2);
16

17
insert into t values(1,2),(3,4),(5,6);
18
select * from t;
19

20
select * from t where c1 in (1,3,1);
21

22
select * from t where c1 in (1,1);
23

24
drop table t;
25