来看下Vertica数据库的一个大坑

drop table if exists xmx_test;
drop table if exists xmx_test1;
create table xmx_test (a numeric(20));
create table xmx_test1 (a varchar(20));
insert into xmx_test values(10116106010000012103);
insert into xmx_test1 values('10116106010000011840');

select case when a.a=b.a then '我艹尼玛的Vertica' END AS VERTICA_SB from xmx_test a 
inner join xmx_test1 b
on a.a =b.a