32390692417
80%

Ran 20 Aug 2026 04:14PM UTC

Jobs 0

Files 0

Run time –

Badge

Embed ▾

pending completion

cancel

Build # 32390692417

Build Type

push

github

Committed by

web-flow

Commit Message

perf(daemon): ordered index for sdk_messages status queries (#2610)

* perf(daemon): ordered index for sdk_messages status queries

Replace idx_sdk_messages_send_status (session_id, send_status) with
idx_sdk_messages_send_status_timestamp (session_id, send_status,
timestamp, id) so getMessagesByStatus satisfies ORDER BY timestamp ASC
directly from the index instead of a temp sort. Migration 197 creates
the ordered index and drops the superseded one; fresh-DB schema and the
space test helper are updated to match.

* fix(daemon): preserve FIFO order for equal-timestamp status reads

Drop the trailing id column from idx_sdk_messages_send_status_timestamp
so equal timestamps tie-break by implicit rowid (insertion order) instead
of random UUID, and make the tie-break explicit in getMessagesByStatus
with ORDER BY timestamp ASC, rowid ASC. Adds a regression test pinning
insertion order for identical timestamps.

* test(daemon): strengthen migration-197 EXPLAIN guard against partial temp sorts

Use /USE TEMP B-TREE/ so the no-sort assertion also fails on
USE TEMP B-TREE FOR RIGHT PART OF ORDER BY, the degradation the rowid
tie-break could produce on some SQLite versions.

Coverage Stats

Source Files on build 32390692417

Detailed source file information is not available for this build.

lsm / HyperNeo / 32390692417
80%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on build 32390692417

lsm / HyperNeo / 32390692417 80%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on build 32390692417

lsm / HyperNeo / 32390692417
80%

README BADGES
x