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

Timestamp:

08/27/15 10:03:48 (9 years ago)

Author:

ascheibe

Message:

#2388 fixed plugin queries for maintenance page

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 [PluginId] IN (
-     SELECT [PluginId] FROM [Plugin]
-     EXCEPT
-     SELECT DISTINCT [p].[PluginId] FROM [Plugin] p, [RequiredPlugins] rp
-     WHERE [p].[PluginId] = [rp].[PluginId])";
+     DELETE FROM [Plugin] WHERE PluginId IN (
+     SELECT p.[PluginId] FROM [Plugin] p
+     LEFT JOIN [RequiredPlugins] rp
+     ON rp.PluginId = p.PluginId
+     WHERE rp.PluginId IS NULL)";
     #endregion
   }