Ignore:
Timestamp:
08/19/15 13:44:42 (7 years ago)
Author:
ascheibe
Message:

#2388 fixed some queries

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/PluginDao.cs

    r12761 r12883  
    5757    #region String queries
    5858    private const string DeleteUnusedPluginsStringQuery = @"
    59       DELETE FROM [Plugin]
    60       WHERE  [Plugin].[PluginId] NOT IN (
    61         SELECT DISTINCT rp.[PluginId]
    62         FROM [RequiredPlugins] rp
    63         WHERE EXISTS (SELECT [TaskId]
    64                       FROM [Task] t
    65                       WHERE t.[TaskId] = rp.[TaskId])
    66       );
    67     ";
     59     DELETE FROM [Plugin] WHERE [PluginId] IN (
     60     SELECT [PluginId] FROM [Plugin]
     61     EXCEPT
     62     SELECT DISTINCT [p].[PluginId] FROM [Plugin] p, [RequiredPlugins] rp
     63     WHERE [p].[PluginId] = [rp].[PluginId])";
    6864    #endregion
    6965  }
Note: See TracChangeset for help on using the changeset viewer.