[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