oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: xiaoyi.xy
5
# owner group: SQL3
6
# description: replace NULL
7
--disable_warnings
8
drop table if exists t1;
9
--enable_warnings
10
create table t1 (c0 int primary key,c1 int, c2 int, c3 int);
11
replace into t1 values (1,null, 1, null);
12
insert into t1 values (2,null, null, null);
13
select * from t1;
14
select * from t1 where (c1, c2) = (null, null) or (c1, c2) = (null, 1);
15