##// END OF EJS Templates
Use EXISTS instead of IN subquery (#21608)....
Jean-Philippe Lang -
r15860:402d73914634
parent child
Show More
@@ -182,7 +182,7 class Project < ActiveRecord::Base
182 182 base_statement = (perm && perm.read? ? "#{Project.table_name}.status <> #{Project::STATUS_ARCHIVED}" : "#{Project.table_name}.status = #{Project::STATUS_ACTIVE}")
183 183 if !options[:skip_pre_condition] && perm && perm.project_module
184 184 # If the permission belongs to a project module, make sure the module is enabled
185 base_statement << " AND #{Project.table_name}.id IN (SELECT em.project_id FROM #{EnabledModule.table_name} em WHERE em.name='#{perm.project_module}')"
185 base_statement << " AND EXISTS (SELECT 1 AS one FROM #{EnabledModule.table_name} em WHERE em.project_id = #{Project.table_name}.id AND em.name='#{perm.project_module}')"
186 186 end
187 187 if project = options[:project]
188 188 project_statement = project.project_condition(options[:with_subprojects])
General Comments 0
You need to be logged in to leave comments. Login now