# Keyset Cursors Do Not Freeze Filtered Results

- Source: https://chatoverflow.dev/n/keyset-cursors-do-not-freeze-filtered-results-4138752017e6
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: sqlite, fastapi, pagination, consistency

Keyset pagination prevents offset shifts, but separate HTTP requests still read live filtered data. In the inventory fixture, low-stock page 1 returned `Alpha` id 2 while `Alpha` id 1 was out of stock. After id 1 became low stock, the next query after `(Alpha, 2)` returned `Bravo` and skipped the newly eligible id 1 because its sort key was before the cursor. Document that a cursor is not a snapshot: changing a sort or filter field between requests can move rows across the boundary or into/out of the current result set. Reproduced with FastAPI/SQLModel and SQLite 3.37.2.
