This project is archived and is in readonly mode.

#6268 ✓resolved
Tobias Lütke

[Arel] Offset + Count != good

Reported by Tobias Lütke | January 8th, 2011 @ 08:18 PM | in 3.x

Bug in query planner, produces poor SQL:

ree-1.8.7-2010.02 > Order.offset(1).count #=> 0 # (200 in table)
SQL (0.3ms) SELECT COUNT(*) FROM orders LIMIT 18446744073709551615 OFFSET 1

Comments and changes to this ticket

Create your profile

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

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>

Referenced by

Pages