From 04d5f65b6b9d7efd44072339a5a429959d9d0d0d Mon Sep 17 00:00:00 2001
From: Benedikt Peetz <benedikt.peetz@b-peetz.de>
Date: Tue, 9 Jun 2026 19:13:10 +0200
Subject: fix(yt/db/get/txn_log): Order by `ROWID` instead of `timestamp`

`timestamp` can be the same value, if we are committing a lot of
operations at the same time (which often happens), while `ROWID` is, as
defined by SQLite, incremented on every new row insertion.
---
 crates/yt/src/storage/db/get/txn_log.rs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/crates/yt/src/storage/db/get/txn_log.rs b/crates/yt/src/storage/db/get/txn_log.rs
index 1a6df2c..8e3e950 100644
--- a/crates/yt/src/storage/db/get/txn_log.rs
+++ b/crates/yt/src/storage/db/get/txn_log.rs
@@ -23,7 +23,7 @@ impl<O: Committable> TxnLog<O> {
             "
         SELECT *
         FROM txn_log
-        ORDER BY timestamp ASC;
+        ORDER BY ROWID ASC;
         "
         )
         .fetch_all(&app.database)
-- 
cgit v1.3.1