#227 ✓resolved

will_paginate appends more limits to already-limited sql

Reported by Adrian | May 29th, 2008 @ 05:51 PM

I have a SQL statement which UNIONs 4 SQLs together.

The SQL also contains a GROUP BY and an ORDER BY.

When clicking Next in the view page, end up with a SQL that ends:

LIMIT 0, 5 LIMIT 5, 5

and causes a failure.

Using MySQL

Rails 2.0.2

Mac OSX 10.4

Latest will_paginate gem (installed today).

Comments and changes to this ticket

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 ยป

Everyone's favorite Ruby library for pagination of practically anything!

People watching this ticket