From 164c37ad3df96849cb727148cade44043264302e Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 19 Feb 2014 10:22:37 -0500 Subject: [PATCH] DB supersedes / deprecates pgtap test repair Sort multi-value arrays before passing them off to pgtap for test comparison. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/t/db_patch_dep_checks.pg | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/t/db_patch_dep_checks.pg b/Open-ILS/src/sql/Pg/t/db_patch_dep_checks.pg index 57c5085cef..19ce243f42 100644 --- a/Open-ILS/src/sql/Pg/t/db_patch_dep_checks.pg +++ b/Open-ILS/src/sql/Pg/t/db_patch_dep_checks.pg @@ -29,7 +29,14 @@ SELECT is( -- AAAF deprecates AAAB, AAAC SELECT is( - (SELECT ARRAY_AGG(patch) FROM evergreen.upgrade_list_applied_deprecates('AAAF')), + ( SELECT ARRAY_AGG(patch) + FROM ( + -- sort the patches to match the expected output + SELECT patch + FROM evergreen.upgrade_list_applied_deprecates('AAAF') + ORDER BY patch + ) AS patch + ), '{AAAB,AAAC}' ); -- 2.11.0