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