Radicore Forum: Bug Reports » Task (Proc) show 100 pagination bug

Home » RADICORE development » Bug Reports » Task (Proc) show 100 pagination bug (Task (Proc) list result in show 100 per page pagination error when over 100 items available)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: (SOLVED) pagination error due to SQL_CALC_FOUND_ROWS bug [message #3877 is a reply to message #3873]

Tue, 12 November 2013 12:58

kong
Messages: 90
Registered: December 2011

Member

Isolated the problem as bug in mySQL 5.6.11

As example, I ran the following SQL statements that Radicore uses to determine numrows (to derive lastpage) for pagination:

SELECT SQL_CALC_FOUND_ROWS pattern_id, pattern_desc, (SELECT COUNT(task_id) FROM mnu_task WHERE mnu_task.pattern_id=mnu_pattern.pattern_id) AS task_count FROM mnu_pattern ORDER BY mnu_pattern.pattern_id asc LIMIT 10 OFFSET 0;
SELECT FOUND_ROWS()

with different numbers for LIMIT to check what FOUND_ROWS returns for different cases of LIMIT. In theory, FOUND_ROWS should yield the same result independently of what LIMIT is, but strangely it does not:

LIMIT RESULT
10 to 18 returns correct value 46
19 to 45 returns LIMIT value as result which is WRONG
46 and above returns correct value 46

I also noticed http://bugs.mysql.com/bug.php?id=62372 which could be related.

Because the behavior is tough to predict, I don't know when and where the problem will appear or disappear while records are being added to the db.

Report message to a moderator

[Message index]

		Task (Proc) show 100 pagination bug By: kong on Fri, 08 November 2013 04:00
		Re: Task (Proc) show 100 pagination bug By: AJM on Sat, 09 November 2013 05:57
		Re: (SOLVED) pagination error due to SQL_CALC_FOUND_ROWS bug By: kong on Tue, 12 November 2013 12:58
		Re: (SOLVED) pagination error due to SQL_CALC_FOUND_ROWS bug By: AJM on Tue, 12 November 2013 14:57

Previous Topic:	Tutorial
Next Topic:	Documentation - typos and misspellings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 11 07:34:20 EST 2025

Total time taken to generate the page: 0.00887 seconds