blob: cfe58ba8a7340c7b3f31e10208b187b9d119b9b9 [file] [log] [blame]
explain plan for select * from (
-- not null predicate
select x, y, z from ( select a1, b1, avg(a1) from t1_v t1 group by a1, b1 ) as sq(x, y, z) where x is not null) t limit 0;