Pagination is wrong when listing consent session on Ory/Hydra

[supercairos]

Preflight checklist

• I could not find a solution in the existing issues, docs, nor discussions.
• I agree to follow this project's Code of Conduct.
• I have read and am following this repository's Contribution Guidelines.
• I have joined the Ory Community Slack.
• I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

No response

Describe the bug

When listing all consent session, Hydra filters out the expired consent sessions.

hydra/persistence/sql/persister_consent.go

Line 548 in eeaf6f0

return p.filterExpiredConsentRequests(ctx, rs)

But when counting the availlable consent sessions, Hydra doesn't filter out the expired consent sessions.

hydra/persistence/sql/persister_consent.go

Line 601 in eeaf6f0

return n, sqlcon.HandleError(err)

Leading to an inconsistency between the pagination and the returned consent session.

Reproducing the bug

Have some expired session in your DB.

List all sessions. notice the pagination header is wrong.

Relevant log output

No response

Relevant configuration

Ory/Hydra 2.2.0

Version

2.2.0

On which operating system are you observing this issue?

Linux

In which environment are you deploying?

Kubernetes with Helm

Additional Context

No response