oceanbase

1
drop table if exists t2;
2
create table t2 (i int primary key, j int);
3
insert into t2 values (1,1),(2,2),(5,null),(4,4),(3,3);
4
select * from t2 where (i) in ((1),(null)) and i = 2;
5
i	j
6
select * from t2 where (i) in ((1),(null)) and i = 1;
7
i	j
8
1	1
9
select * from t2 where (i) in ((1),(null));
10
i	j
11
1	1
12
select * from t2 where (i) in ((1),(null)) and i = 1 and i = 2;
13
i	j
14
update t2 set j=i+1 where i=2;
15
select * from t2;
16
i	j
17
1	1
18
2	3
19
3	3
20
4	4
21
5	NULL
22
drop table t2;
23