Ignore:
Timestamp:
08/27/15 10:03:48 (7 years ago)
Author:
ascheibe
Message:

#2388 fixed plugin queries for maintenance page

File:
1 edited

Legend:

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

    r12883 r12914  
    5757    #region String queries
    5858    private const string DeleteUnusedPluginsStringQuery = @"
    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])";
     59     DELETE FROM [Plugin] WHERE PluginId IN (
     60     SELECT p.[PluginId] FROM [Plugin] p
     61     LEFT JOIN [RequiredPlugins] rp
     62     ON rp.PluginId = p.PluginId
     63     WHERE rp.PluginId IS NULL)";
    6464    #endregion
    6565  }
Note: See TracChangeset for help on using the changeset viewer.