Trac Report - using LIMIT option in a SQL query is not consistent with the 'Max items per page' setting

[motumboe@…]

I have a track report with the following SQL:

SELECT name as milestone FROM milestone ORDER BY name DESC LIMIT 2000

I have 561 milestones in my trac system, so it shows a page with 561 milestones. However, there are 6 buttons (1,2,3,4,5,6); if I click on 2 I get a heading with "(101 - 661 of 561)", but in fact, I still get all the 561 milestones.

[Ryan J Ollos]

Confirmed, pagination doesn't work correctly when the query includes a LIMIT clause.

[Jun Omae]

I think the query should be the following.

SELECT * FROM (SELECT name as milestone FROM milestone ORDER BY name DESC LIMIT 2000) AS t
@LIMIT_OFFSET@

See TracReports#rewriting, [11096] and #10540.

[Ryan J Ollos]

Thanks, I wasn't very familiar with reports. Your suggestion works well.