From fbda8c2064916da3fdd83ffdb2b5f99afa8642d0 Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Fri, 1 Sep 2017 17:09:36 -0400 Subject: [PATCH] LP1714589: Use Explicit Definition for aacs Spell out the expected fields in the expected order for the aacs view because databases that have undergone upgrades may drift when using * in a UNION. Signed-off-by: Signed-off-by: Mike Rylander --- .../sql/Pg/upgrade/1051.schema.all-circs-slim.sql | 35 +++++++++++++++++++++- 1 file changed, 34 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/1051.schema.all-circs-slim.sql b/Open-ILS/src/sql/Pg/upgrade/1051.schema.all-circs-slim.sql index 71c22f199a..5a412753c9 100644 --- a/Open-ILS/src/sql/Pg/upgrade/1051.schema.all-circs-slim.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1051.schema.all-circs-slim.sql @@ -3,7 +3,40 @@ BEGIN; SELECT evergreen.upgrade_deps_block_check('1051', :eg_version); CREATE OR REPLACE VIEW action.all_circulation_slim AS - SELECT * FROM action.circulation + SELECT + id, + usr, + xact_start, + xact_finish, + unrecovered, + target_copy, + circ_lib, + circ_staff, + checkin_staff, + checkin_lib, + renewal_remaining, + grace_period, + due_date, + stop_fines_time, + checkin_time, + create_time, + duration, + fine_interval, + recurring_fine, + max_fine, + phone_renewal, + desk_renewal, + opac_renewal, + duration_rule, + recurring_fine_rule, + max_fine_rule, + stop_fines, + workstation, + checkin_workstation, + copy_location, + checkin_scan_time, + parent_circ + FROM action.circulation UNION ALL SELECT id, -- 2.11.0