From 66de9fcd09fb35a802b9ac00f6f8bd44cb484664 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 30 Oct 2018 12:04:56 -0700 Subject: [PATCH] JBAS-1839 Stock browse migration create_date repair Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/stock-browse-schema.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/stock-browse-schema.sql b/KCLS/sql/schema/deploy/stock-browse-schema.sql index cd9897eb5d..c35bfe74c5 100644 --- a/KCLS/sql/schema/deploy/stock-browse-schema.sql +++ b/KCLS/sql/schema/deploy/stock-browse-schema.sql @@ -770,8 +770,9 @@ BEGIN -- existing entries do not have truncated sort values that -- contain both sort value and value. fix that here. INSERT INTO metabib.browse_entry - (value, index_vector, sort_value, combo_sort_value) + (create_date, value, index_vector, sort_value, combo_sort_value) SELECT + legacy_entry.create_date, legacy_entry.value, legacy_entry.index_vector, legacy_entry.sort_value, -- 2.11.0