create table t (a string);

insert into t values ('1'),('x'),('2.0');

explain
select * from t where a in (1.0,'x',2);
select * from t where a in (1.0,'x',2);


create table ax(s char(1),t char(10));
insert into ax values ('a','a'),('a','a '),('b','bb');
select 'expected 1',count(*) from ax where ((s,t) in (('a','a'),(null, 'bb'))) is null;