The calculation of length of report is wrong in case of a select with GROUP BY.
Created attachment 3759 [details] [review]
Created attachment 3778 [details] [review]
Precedent patch deletes too many functions
Created attachment 3798 [details] [review]
Replace stupid previous patch
Count of row in reports with GROUP BY is ok.
Testing the most recent version of the attached patch, and it works. Signed off patch sent to list.
*** Bug 3315 has been marked as a duplicate of this bug. ***
Pushed, please test
I think the patch didn't fix the problem. The number of results shown is correct. But I get no pagination.
My test was:
select * from borrowers group by borrowernumber, categorycode
This makes not much sense, but gives a result list long enough to cause pagination.
After running the report I got:
Total number of rows matching the (unlimited) query is 50.
The first 20 results were shown, the following results not.
Pagination is broken in general on this page. Filing separate bug and sending patch.
This works nicely in 3.6.3. Marking resolved.