From c68c2b8137e764efd5e9e4f07dc8ff196f6b6918 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 26 Oct 2015 12:26:03 -0400 Subject: [PATCH] JBAS-944 vandelay.overlay_bib_record always set edit_date Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql index a31a7c6f78..ffa2c78f12 100644 --- a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql @@ -8339,10 +8339,17 @@ BEGIN IF editor_id IS NOT NULL THEN --only update the edit date if we have a valid editor - update_fields := ARRAY_APPEND(update_fields, 'editor = ' || editor_id || ', edit_date = NOW()'); + -- KCLS always wants edit_date to be updated + -- update_fields := ARRAY_APPEND(update_fields, 'editor = ' || editor_id || ', edit_date = NOW()'); + update_fields := ARRAY_APPEND(update_fields, 'editor = ' || editor_id); + -- /KCLS END IF; END IF; + -- KCLS always wants edit_date to be updated + update_fields := ARRAY_APPEND(update_fields, 'edit_date = NOW()'); + -- /KCLS + IF v_bib_source IS NOT NULL THEN update_fields := ARRAY_APPEND(update_fields, 'source = ' || v_bib_source); END IF; -- 2.11.0