From 5893a2bd6df4b36e07bdb5186a389a343b1ac80a Mon Sep 17 00:00:00 2001 From: Lebbeous Fogle-Weekley Date: Fri, 30 Sep 2011 16:59:32 -0400 Subject: [PATCH] Preserver ordering in wrapped calls to in-db authority browse/search methods Signed-off-by: Lebbeous Fogle-Weekley --- .../lib/OpenILS/Application/Storage/Publisher/authority.pm | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/authority.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/authority.pm index e510439e4f..5de1381e46 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/authority.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/authority.pm @@ -274,10 +274,9 @@ sub authority_in_db_browse { my $db = authority::full_rec->db_Main; my $list = $db->selectcol_arrayref( qq/ - SELECT ash.record - FROM (SELECT * FROM authority.$method(?,?,?,?)) func - JOIN authority.simple_heading ash ON - (ash.id = func.$method); + SELECT + (SELECT record FROM authority.simple_heading WHERE id = func.heading) + FROM authority.$method(?, ?, ?, ?) func(heading) /, {}, @args ); -- 2.11.0