[dev] counting in buildAttributeQuery
Duck
duck at obala.net
Fri Sep 3 09:20:30 PDT 2004
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.
Duck
-------------- next part --------------
A non-text attachment was scrubbed...
Name: distinct.patch
Type: text/x-diff
Size: 952 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20040903/ac2df9eb/distinct.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: group.patch
Type: text/x-diff
Size: 1197 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20040903/ac2df9eb/group.bin
More information about the dev
mailing list