oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: yuchen.wyc
5
# owner group: SQL1
6
# Test of functions get
7
--disable_warnings
8
drop table if exists t2;
9
--enable_warnings
10
create table t2 (i int primary key, j int);
11
insert into t2 values (1,1),(2,2),(5,null),(4,4),(3,3);
12
select * from t2 where (i) in ((1),(null)) and i = 2;
13
select * from t2 where (i) in ((1),(null)) and i = 1;
14
select * from t2 where (i) in ((1),(null));
15
select * from t2 where (i) in ((1),(null)) and i = 1 and i = 2;
16
update t2 set j=i+1 where i=2;
17
select * from t2;
18
drop table t2;
19