Changeset 7282

Timestamp:

Jan 25, 2017, 2:56:04 PM (6 years ago)

Author:

Nicklas Nordborg

Message:

References #2049: Project-specific annotations

We need a different query in MySQL to make sure project-specific annotations are correctly referenced. There are several other similar queries in use. This was the only one that happened to fail in the TestAnnotation test. I think we need to manually try to test that the other queries are working as well. If they don't it would be good to design test cases that trigger them to be executed.

File:

• branches/3.10-stable/config/dist/mysql-queries.xml (modified) (1 diff)

branches/3.10-stable/config/dist/mysql-queries.xml

@@ -87 +87 @@
   </query>
 
+  <query id="PS_FIND_OVERRIDE_ID_FOR_PROJECT_ANNOTATION" type="SQL">
+    <sql>
+      UPDATE [Annotations] 
+      SET [override_id] = COALESCE(
+        (SELECT [tmp].[id] FROM
+          (SELECT [id] FROM [Annotations] 
+          WHERE [annotationset_id] = :annotationSetId
+          AND [annotationtype_id] = :annotationTypeId
+          AND [source] = 0 AND [project_id] = 0) [tmp]
+        ) 
+        , 0)
+      WHERE id = :annotationId
+    </sql>
+    <description>
+      Updates the "override_id" column on a newly created project-specific 
+      (PRIMARY) annotation to point to the existing default annotation id
+      or 0 if no default annotation exists. To make this query work in MySQL
+      we need a double inner subselect to force a temporary table for the
+      single value we are after.
+    </description>
+  </query>
 
 </predefined-queries>