[dev] counting in buildAttributeQuery

Chuck Hagenbuch chuck at horde.org
Fri Sep 3 09:24:04 PDT 2004


Quoting Duck <duck at obala.net>:

> I started to implement limiting in ansel selection and found out that the
> COUNT don't return the right value. seems that the GROUP BY makes trouble (in
> mysql surely, I dont know in other databases). It come out that the count
> returns count values for every row. I added the patches to choose from, that
> fix this issue. One uses DISTINCT for botch counting ans selecting. And the
> other leave GROUP BY for selecting and introduces DISTINCT for counting.

I've committed the all-DISTINCT version, thanks.

-chuck

--
"Regard my poor demoralized mule!" - Juan Valdez


More information about the dev mailing list