`raw_rnum_` being added to queried results and paged results wrong. about will_paginate

[mislav]

Hi, sorry that you're having trouble, but this doesn't sound like an issue caused by will_paginate. This library does not add any attribute called raw_rnum_ to your records. Also note that will_paginate does not actually construct your SQL queries: Active Record does, so you might have been affected by the ActiveRecord upgrade, not how will_paginate works with it.

[vinibol12]

Turns out it was an oracle adapter issue. Sorry for blaming it on will_paginate. The issue went away when I removed pagination so it seemed logical to me. But I was clearly wrong.

…

On Tue, May 3, 2022, 11:35 Mislav Marohnić ***@***.***> wrote: Hi, sorry that you're having trouble, but this doesn't sound like an issue caused by will_paginate. This library does not add any attribute called raw_rnum_ to your records. Also note that will_paginate does not actually construct your SQL queries: Active Record does, so you might have been affected by the ActiveRecord upgrade, not how will_paginate works with it. — Reply to this email directly, view it on GitHub <#637 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACHXKLPNU6SDOE2EFILEDFDVIE2TNANCNFSM5UNXDMEQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[mislav]

@vinibol12 will_paginate library performs pagination by adding LIMIT and OFFSET clauses (or equivalents, depending on the underlying database engine) to the SQL query using ActiveRecord. It might be possible that Active Record generates wrong queries with LIMIT and OFFSET in the Oracle adapter.