LightDB 支持number和boolean类型比较

功能简介

为了兼容ORACLE数据库语法，LightDB从23.2版本开始支持NUMBER类型和BOOL类型的比较。
但是仅是支持相等（“=”）和不相等（“<>”）两个运算符，且仅限于ORACLE兼容模式下。
NUMBER是作为NUMERIC的别名实现的，下面以NUMERIC描述:

1. 支持 numeric = Boolean 和 Boolean = numeric, number <> Boolean, Boolean
   <> numeric4种重载；
2. numeric为0时和false相等；
3. numeric为1时和true相等；
4. numeric既不等于0也不等于1的时候，和true，false都不相等；

用法

select 0::numeric = true;
 ?column? 
----------
 f
(1 row)

select 1::numeric = true;
 ?column? 
----------
 t
(1 row)

select 0::numeric = false;
 ?column? 
----------
 t
(1 row)

select 1::numeric = false;
 ?column? 
----------
 f
(1 row)

select 1.1::numeric(10,0) = true;
 ?column? 
----------
 t
(1 row)

select 0.1::numeric(10,0) = true;
 ?column? 
----------
 f
(1 row)

select 1.1::numeric(10,0) = false;
 ?column? 
----------
 f
(1 row)

select 0.1::numeric(10,0) = false;
 ?column? 
----------
 t
(1 row)

select 2::numeric = false;
 ?column? 
----------
 f
(1 row)

select 2::numeric = true;
 ?column? 
----------
 f
(1 row)

select true = 0::numeric;
 ?column? 
----------
 f
(1 row)

select true = 1::numeric;
 ?column? 
----------
 t
(1 row)

select false = 0::numeric;
 ?column? 
----------
 t
(1 row)

select false = 1::numeric;
 ?column? 
----------
 f
(1 row)

select true = 1.1::numeric(10,0);
 ?column? 
----------
 t
(1 row)

select true = 0.1::numeric(10,0);
 ?column? 
----------
 f
(1 row)

select false = 1.1::numeric(10,0);
 ?column? 
----------
 f
(1 row)

select false = 0.1::numeric(10,0);
 ?column? 
----------
 t
(1 row)

select false = 2::numeric;
 ?column? 
----------
 f
(1 row)

select true = 2::numeric;
 ?column? 
----------
 f
(1 row)

select 0::numeric <> true;
 ?column? 
----------
 t
(1 row)

select 1::numeric <> true;
 ?column? 
----------
 f
(1 row)

select 0::numeric <> false;
 ?column? 
----------
 f
(1 row)

select 1::numeric <> false;
 ?column? 
----------
 t
(1 row)

select 1.1::numeric(10,0) <> true;
 ?column? 
----------
 f
(1 row)

select 0.1::numeric(10,0) <> true;
 ?column? 
----------
 t
(1 row)

select 1.1::numeric(10,0) <> false;
 ?column? 
----------
 t
(1 row)

select 0.1::numeric(10,0) <> false;
 ?column? 
----------
 f
(1 row)

select 2::numeric <> false;
 ?column? 
----------
 f
(1 row)

select 2::numeric <> true;
 ?column? 
----------
 f
(1 row)


select true <> 0::numeric;
 ?column? 
----------
 t
(1 row)

select true <> 1::numeric;
 ?column? 
----------
 f
(1 row)

select false <> 0::numeric;
 ?column? 
----------
 f
(1 row)

select false <> 1::numeric;
 ?column? 
----------
 t
(1 row)

select true <> 1.1::numeric(10,0);
 ?column? 
----------
 f
(1 row)

select true <> 0.1::numeric(10,0);
 ?column? 
----------
 t
(1 row)

select false <> 1.1::numeric(10,0);
 ?column? 
----------
 t
(1 row)

select false <> 0.1::numeric(10,0);
 ?column? 
----------
 f
(1 row)

select false <> 2::numeric;
 ?column? 
----------
 f
(1 row)

select true <> 2::numeric;
 ?column? 
----------
 f
(1 row)