From b41cf0cbd359cc5a4d1da39c98c67a29eb6e99f9 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 15 Nov 2018 12:36:55 -0500 Subject: [PATCH] JBAS-2113 Merge 1134 DB change Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql b/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql index 1759868a23..8452f9cd4a 100644 --- a/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql +++ b/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql @@ -7234,7 +7234,7 @@ BEGIN SELECT INTO result_row.sources COUNT(DISTINCT b.id) FROM biblio.record_entry b - JOIN asset.copy_vis_attr_cache acvac ON (acvac.record = b.id) + LEFT JOIN asset.copy_vis_attr_cache acvac ON (acvac.record = b.id) WHERE b.id = ANY(all_brecords[1:browse_superpage_size]) AND ( acvac.vis_attr_vector @@ c_tests::query_int @@ -7250,7 +7250,7 @@ BEGIN SELECT INTO result_row.asources COUNT(DISTINCT b.id) FROM biblio.record_entry b - JOIN asset.copy_vis_attr_cache acvac ON (acvac.record = b.id) + LEFT JOIN asset.copy_vis_attr_cache acvac ON (acvac.record = b.id) WHERE b.id = ANY(all_arecords[1:browse_superpage_size]) AND ( acvac.vis_attr_vector @@ c_tests::query_int @@ -22064,6 +22064,7 @@ PERFORM evergreen.upgrade_deps_block_check('1130', '3.2.1'); PERFORM evergreen.upgrade_deps_block_check('1131', '3.2.1'); PERFORM evergreen.upgrade_deps_block_check('1132', '3.2.1'); -- remingtron/csharp PERFORM evergreen.upgrade_deps_block_check('1133', '3.2.1'); +PERFORM evergreen.upgrade_deps_block_check('1134', '3.2.1'); END IF; END $INSERT$; -- 2.11.0