condense count

[j.yu@…]

select condense + over x in sdom(a) where a[x] using 1 from mr as a — for cell count is not correct, get from ql-guide 9.6
should be
select condense + over x in sdom(a) where (bool)a[x] using 1 from mr as a
but if a[x]=0 the result is not correct either,
so
select condense + over x in sdom(a) where (bool)((bool)a[x]+1) using 1 from mr as a
could be a solution

[Peter Baumann]

hm, count_cells() should count all non-zero cells, right?
So this should do:

select condense + over x in sdom(a) where a[x]!=0 using 1
from mr as a

or

select condense + over x in sdom(a) using a[x]!=0
from mr as a

Please let me know what to write.

[Dimitar Misev]

First one is right, the second results in a boolean (true)..

[Peter Baumann]

fixed with documentation 8.4.