The following 2 queries must be the same result but not , and the query 2 is expected
query1:
select
co,co2,co3,num
from (
select co,co2,co3,count() as num from (
select 1 as co,2 as co2 ,3 as co3
) group by cube (co,co2,co3)
)
where co!=0
and co2 !=2

query2:
select co,co2,co3,count() as num from (
select 1 as co,2 as co2 ,3 as co3
) group by cube (co,co2,co3)
having co!=0
and co2 !=2