aboutsummaryrefslogtreecommitdiff
path: root/drizzle/0001_big_rachel_grey.sql
diff options
context:
space:
mode:
authorMartin Kagamino Lehoux <martin@lehoux.net>2026-10-06 00:46:53 +0200
committerMartin Kagamino Lehoux <martin@lehoux.net>2026-10-06 00:46:53 +0200
commitc915f91fbe8d97201d813c792f4e1fe8c4401e15 (patch)
tree7b341e4d7548205776557437bd2245ec59bf0a57 /drizzle/0001_big_rachel_grey.sql
parentf7366834ee41bbb4ac8a9a252224241a884af41b (diff)
fix: make grocery and reference ordering deterministic
Every list query lacked a tiebreak, so rows sharing a sort key (same-ms createdAt inserts, tied or NULL quality scores) came back in unspecified order and bestRef flipped between loads. Add explicit tiebreaks: items createdAt desc, id desc (newest first); references qualityScore desc, id asc (first inserted wins ties). Categories were already total (order, name unique). Pin the rules with service tests.
Diffstat (limited to 'drizzle/0001_big_rachel_grey.sql')
0 files changed, 0 insertions, 0 deletions