create table rdf_test(v1 number); insert into rdf_test values(1); select count(*) from rdf_test where v1 = 1; COUNT(*) ======== 1 select count(*) from rdf_test where v1 = '1'; COUNT(*) ======== 1 select count(*) from rdf_test where v1 = '1.0'; COUNT(*) ======== 1