From ff183e33aa0710615245e9cf45c5420f00dda123 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Andreas=20M=C3=BCller?= Date: Fri, 11 May 2018 13:44:23 +0200 Subject: [PATCH] ref #7144 fix update script for country levels --- .../cdm/database/update/v47_49/SchemaUpdater_47_49.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java index f0ab448c79..066f5b4a85 100644 --- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java +++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java @@ -215,7 +215,7 @@ public class SchemaUpdater_47_49 extends SchemaUpdaterBase { //#7144 Set Country area level stepName = "Set Country area level"; query = " UPDATE @@DefinedTermBase@@ " + - " SET level_id = (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') " + + " SET level_id = ( SELECT id FROM (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') as drv) " + " WHERE DTYPE = 'Country' "; step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); stepList.add(step); -- 2.34.1