#61 open

total_hits incorrect when group_by used (group_by option used in actual select, but ignored in count)

Reported by Jens | February 13th, 2010 @ 12:39 AM

find_with_ferret accepts normal finder options as the third param. When those options include a group_by clause, the clause is applied in the actual results returned, but NOT in the "SELECT count(*) as count_all" query. As a result, total_hits is incorrect, which means paging is incorrect, which is a big problem (three pages of results, with links to 7 pages -- not great for the end user).

SVN: 534

No comments found

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Shared Ticket Bins

People watching this ticket