Attachment 159367 Details for Bug 35442 – Bug 35442: Script migration_tools/build_oai_sets.pl add ORDER BY

[patch] Bug 35442: Script migration_tools/build_oai_sets.pl add ORDER BY

Bug-35442-Script-migrationtoolsbuildoaisetspl-add-.patch (text/plain), 1.16 KB, created by Fridolin Somers on 2023-11-29 19:55:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Fridolin Somers

Created: 2023-11-29 19:55:33 UTC

Size: 1.16 KB

patch

obsolete

>From a6b98c2ca38a5ba6ea80344a74ea2e64972c1c4e Mon Sep 17 00:00:00 2001
>From: Fridolin Somers <fridolin.somers@biblibre.com>
>Date: Wed, 29 Nov 2023 09:53:03 -1000
>Subject: [PATCH] Bug 35442: Script migration_tools/build_oai_sets.pl add ORDER
> BY
>
>Script migration_tools/build_oai_sets.pl is missing ORDER BY biblionumber.
>This is a problem when using OFFSET and LIMIT, the results may be differenly orderder between two calls of this script.
>
>Test plan :
>1) Create a OAI SET with all records
>2) Run migration_tools/build_oai_sets.pl with the first half of records
>3) Run migration_tools/build_oai_sets.pl with the second half of records
>4) Check all records are in the OAI set
>---
> misc/migration_tools/build_oai_sets.pl | 1 +
> 1 file changed, 1 insertion(+)
>
>diff --git a/misc/migration_tools/build_oai_sets.pl b/misc/migration_tools/build_oai_sets.pl
>index a312d3e0f9..24b842b4de 100755
>--- a/misc/migration_tools/build_oai_sets.pl
>+++ b/misc/migration_tools/build_oai_sets.pl
>@@ -88,6 +88,7 @@ my $query = qq{
>     FROM deletedbiblio_metadata
>     WHERE format='marcxml'
>     AND  `schema` = ?
>+    ORDER BY biblionumber ASC
> };
> if($length) {
>     $query .= "LIMIT $length";
>-- 
>2.43.0

Actions: View | Diff | Splinter Review

Attachments on bug 35442: 159367 | 166783 | 171830