diff options
| -rw-r--r-- | lib/redmine/nested_set/issue_nested_set.rb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/redmine/nested_set/issue_nested_set.rb b/lib/redmine/nested_set/issue_nested_set.rb index 5a6af9440..9d525293f 100644 --- a/lib/redmine/nested_set/issue_nested_set.rb +++ b/lib/redmine/nested_set/issue_nested_set.rb @@ -153,8 +153,8 @@ module Redmine if self.class.connection.adapter_name =~ /sqlserver/i lock = "WITH (ROWLOCK HOLDLOCK UPDLOCK)" end - sets_to_lock = [id, parent_id].compact - self.class.reorder(:id).where("root_id IN (SELECT root_id FROM #{self.class.table_name} WHERE id IN (?))", sets_to_lock).lock(lock).ids + sets_to_lock = [root_id, parent.try(:root_id)].compact.uniq + self.class.reorder(:id).where(:root_id => sets_to_lock).lock(lock).ids end def nested_set_scope |