blob: d559cdbefc6afb2d57e47a69b9c12de59afbfd6b [file] [log] [blame]
create table t (a smallint, b string);
insert into t values (1, 'a');
insert into t values (2, 'aa');
insert into t values (6, 'aaaaaa');
select 1 from t where a in (1,2,3) and case a when 1 then true when 2 then true end;
explain cbo select 1 from t where a in (1,2,3) and case a when 1 then true when 2 then true end;
select 1 from t where a in (1,2,3) and case when a = 1 then true when a = 2 then true end;
explain cbo select 1 from t where a in (1,2,3) and case when a = 1 then true when a = 2 then true end;