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: 测试<＝>运算符
7
--disable_warnings
8
drop table if exists t1,t2;
9
--enable_warnings
10
create table t1(a int, b int, c int, d int, primary key(a));
11
insert into t1 values(1,2,3,4);
12
insert into t1 values(2,null,3,4);
13
insert into t1 values(3,null,null,4);
14
insert into t1 values(4,2,null,null);
15
create table t2(a int, b int, c int, d int, primary key(a,b));
16
insert into t2 values(1,2,3,4);
17
insert into t2 values(2,2,3,4);
18
insert into t2 values(3,3,null,4);
19
insert into t2 values(4,2,null,null);
20

21

22
select 1<=>1;
23
select 1<=>null;
24
select null<=>1;
25
select null<=>null;
26
select 1.0<=>1.0;
27
select 1.0<=>null;
28
select null<=>1.0;
29
select 'abc'<=>null;
30
select 'abc'<=>'abc';
31
select 'null'<=>null;
32
select (1,2,3)<=>(1,2,3);
33
select (1,null, 3) <=> (1,null,3);
34
select (1,null,'abc')<=>(1,null,'abc');
35
select * from t1 where b<=>null;
36
select * from t1 where a<=>2;
37
select * from t1 where a<=>2 and b<=>null;
38
select * from t1 where b<=>null and c<=>null;
39
select * from t1 where b=null and c=null;
40
select * from t1 where b<=>null and c=null;
41
select * from t1 join t2 on t1.a=t2.a;
42
select * from t1 join t2 on t1.a=t2.a where t1.b<=>null and t2.b<=>null;
43

44

45
select * from t1 join t2 on t1.a<=>t2.a;
46