Confusion when displaying second+ pages: .count doesn't work any more about kaminari HOT 3 CLOSED

Yes, I agree that limit + offset + count query returns something unexpected, but it's because that's the way SQL acts.

SELECT COUNT(*) FROM "users" 

=> 100

SELECT COUNT(*) FROM "users" LIMIT 10 OFFSET 10

=> 0

Kaminari and AR and Arel just uses this as it is, thus the following query returns 0.

User.limit(10).offset(10).count

If you want this query to return something different, I'm sorry but that's not Kaminari's matter. I think we should improve ActiveRecord or Arel.
You said, you expect count to return total_count, but I guess some people might expect the same value with length rather than total_count.

Anyway, to work around this ATM, you can use length or all.count for the limited list count, and total_count or except(:offset, :limit).count for the whole record count.
As for any?, exists? or all.any? would work as expected.

from kaminari.

Yeah, makes sense. I can see where most of the time you want count to return the real count of records you've pulled from the DB, not the total number of records that exist in the DB. total_count was a good compromise, I've updated my code to use that. Thanks for getting back so quick!

from kaminari.

Same issue with present?

from kaminari.