Changeset 12883 for trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos

Timestamp:

08/19/15 13:44:42 (9 years ago)

Author:

ascheibe

Message:

#2388 fixed some queries

File:

• trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.cs (modified) (1 diff)

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.cs

@@ -57 +57 @@
     #region String queries
     private const string DeleteUnusedPluginsStringQuery = @"
-      DELETE FROM [Plugin]
-      WHERE  [Plugin].[PluginId] NOT IN (
-        SELECT DISTINCT rp.[PluginId] 
-        FROM [RequiredPlugins] rp
-        WHERE EXISTS (SELECT [TaskId] 
-                      FROM [Task] t
-                      WHERE t.[TaskId] = rp.[TaskId])
-      );
-    ";
+     DELETE FROM [Plugin] WHERE [PluginId] IN (
+     SELECT [PluginId] FROM [Plugin]
+     EXCEPT
+     SELECT DISTINCT [p].[PluginId] FROM [Plugin] p, [RequiredPlugins] rp
+     WHERE [p].[PluginId] = [rp].[PluginId])";
     #endregion
   }