Fix search paging under record locks and in per-table mode #16

Closed
opened 2026-10-06 12:23:25 +00:00 by KofTwentyTwo · 0 comments
KofTwentyTwo commented 2026-10-06 12:23:25 +00:00 (Migrated from github.com)

In QuickSearchAction:

  • With record locks on, offset counts raw OpenSearch positions rather than accessible results, so pages can overlap when hits are filtered.
  • Per-table mode ignores offset.
  • fetchSize (2 x limitPerTable) can pass the 10,000 result window when maxSearchLimit is above 5,000; cap it.

Found in the PR #10 review. The hasMore and duplicate-table defects were already fixed in #10.

Part of #12.

In `QuickSearchAction`: - With record locks on, `offset` counts raw OpenSearch positions rather than accessible results, so pages can overlap when hits are filtered. - Per-table mode ignores `offset`. - `fetchSize` (2 x `limitPerTable`) can pass the 10,000 result window when `maxSearchLimit` is above 5,000; cap it. Found in the PR #10 review. The `hasMore` and duplicate-table defects were already fixed in #10. Part of #12.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: QRun-IO/qbit-quick-search#16