From 3b570d2a24b0d6f59921b72b86685b3d4ac3d229 Mon Sep 17 00:00:00 2001
From: Arik Sosman <git@arik.io>
Date: Thu, 19 Oct 2023 11:52:06 -0700
Subject: [PATCH] Fix expired value being sent as the latest update.

---
 src/lookup.rs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/lookup.rs b/src/lookup.rs
index 8def6f1..0878860 100644
--- a/src/lookup.rs
+++ b/src/lookup.rs
@@ -288,7 +288,7 @@ pub(super) async fn fetch_channel_updates<L: Deref>(delta_set: &mut DeltaSet, cl
 		SELECT id, direction, blob_signed, CAST(EXTRACT('epoch' from seen) AS BIGINT) AS seen
 		FROM channel_updates
 		WHERE seen >= TO_TIMESTAMP($1)
-		ORDER BY timestamp DESC
+		ORDER BY short_channel_id ASC, timestamp DESC
 		", [last_sync_timestamp_float]).await.unwrap();
 	let mut pinned_updates = Box::pin(intermediate_updates);
 	log_info!(logger, "Fetched intermediate rows in {:?}", start.elapsed());
-- 
2.39.5