[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