From 8a1edc32923d63e1a33af2e26fc305dc746b43ee Mon Sep 17 00:00:00 2001 From: Ere Maijala Date: Mon, 21 Feb 2022 16:07:00 +0200 Subject: [PATCH] Bug 30143: OAI-PMH: Fix SQL query used to fetch deleted records The query was missing the "ORDER BY" and "LIMIT" clauses, which could make retrieve a wrong set of records. --- Koha/OAI/Server/ListBase.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Koha/OAI/Server/ListBase.pm b/Koha/OAI/Server/ListBase.pm index 4f1092d146..283f1b3334 100644 --- a/Koha/OAI/Server/ListBase.pm +++ b/Koha/OAI/Server/ListBase.pm @@ -116,7 +116,7 @@ sub GetRecords { $sql = " SELECT biblionumber FROM $table main - WHERE $where + WHERE $where $order_limit "; $ts_sql = "SELECT max(timestamp) FROM $table WHERE biblionumber = ?"; -- 2.25.1