From 9bb417e7cdfcf25ffed148df72ccdfad2c76e864 Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 13 Dec 2010 17:53:34 +0000 Subject: [PATCH] bring 1.6.1-1.6.2 upgrade script in line with r18993. git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_2@18994 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.1-1.6.2-upgrade-db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/1.6.1-1.6.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-1.6.2-upgrade-db.sql index f569df8776..d68146a3c6 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-1.6.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-1.6.2-upgrade-db.sql @@ -27,7 +27,7 @@ BEGIN SELECT DISTINCT ON (hard_due_date) * FROM config.hard_due_date_values WHERE active_date <= NOW() -- We've passed (or are at) the rollover time - ORDER BY active_date DESC -- Latest (nearest to us) active time + ORDER BY hard_due_date, active_date DESC -- Latest (nearest to us) active time LOOP UPDATE config.hard_due_date SET ceiling_date = temp_value.ceiling_date -- 2.11.0