From: Arik Sosman <git@arik.io>
Date: Thu, 19 Oct 2023 18:52:06 +0000 (-0700)
Subject: Fix expired value being sent as the latest update.
X-Git-Url: http://git.bitcoin.ninja/index.cgi?p=rapid-gossip-sync-server;a=commitdiff_plain;h=3b570d2a24b0d6f59921b72b86685b3d4ac3d229

Fix expired value being sent as the latest update.
---

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());