From 949b355ef213dcab4b88e15203503c658f01035e 2011-04-12 16:31:00
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: 2011-04-12 16:31:00
Subject: [PATCH] Fixed: ambiguous lft column SQL error on Issue#descendants with a join on projects.

git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5441 e93f8b46-1217-0410-a6f0-8f06a7374b81

---

diff --git a/test/unit/issue_test.rb b/test/unit/issue_test.rb
index 1049330..ff98711 100644
--- a/test/unit/issue_test.rb
+++ b/test/unit/issue_test.rb
@@ -164,6 +164,10 @@ class IssueTest < ActiveSupport::TestCase
     assert_equal [], projects.select {|p| !p.is_or_is_descendant_of?(project)}
   end
   
+  def test_visible_and_nested_set_scopes
+    assert_equal 0, Issue.find(1).descendants.visible.all.size
+  end
+  
   def test_errors_full_messages_should_include_custom_fields_errors
     field = IssueCustomField.find_by_name('Database')
     
diff --git a/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb b/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb
index b1e5ae1..f46fb43 100644
--- a/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb
+++ b/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb
@@ -425,7 +425,7 @@ module CollectiveIdea #:nodoc:
         # the base ActiveRecord class, using the :scope declared in the acts_as_nested_set
         # declaration.
         def nested_set_scope
-          options = {:order => quoted_left_column_name}
+          options = {:order => "#{self.class.table_name}.#{quoted_left_column_name}"}
           scopes = Array(acts_as_nested_set_options[:scope])
           options[:conditions] = scopes.inject({}) do |conditions,attr|
             conditions.merge attr => self[attr]