Ultimate

X_QUERY_NOT_PAGEABLE

Means

a read returned rows with no id, so a cursor cannot name a position

Typical cause

a projection or aggregate that drops the primary key — the id is the tiebreak that makes the sort order total

Fix

return the key from the query's sql:, e.g. db.posts.select({ id: true, … })

Listed under Policy and authz

This page as markdown