ANY_VALUE ignores FILTER

create table t (a int, b int, key(b));

insert into t values (10,1),(20,1),(30,2),(null,2),(40,2);

select any_value(a) filter (where a=20) from t;

select b, any_value(a) filter (where a>15) from t group by b;

drop table t;

create table t (a int, b int, key(b));

insert into t values (10,1),(20,1),(30,2),(null,2),(40,2);

select any_value(a) filter (where a=20) from t;

any_value(a) filter (where a=20)

10

select b, any_value(a) filter (where a>15) from t group by b;

b	any_value(a) filter (where a>15)

1	NULL

2	30