ref #7144 fix update script for country levels

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 f0ab448c79c058e376327579547d196b71d3435f..066f5b4a85eb1dfba47fd9f41ad5ee47cf64dc22 100644 (file)
--- 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);