From ce1d14430f3ff5c8743541ce5f10b71a083f9c90 Mon Sep 17 00:00:00 2001 From: Rick Olson Date: Fri, 13 Oct 2006 07:46:38 +0000 Subject: add test for select_limited_ids_list that passes in mysql/sqlite and fails in postgresql git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5290 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- activerecord/test/associations_test.rb | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'activerecord/test/associations_test.rb') diff --git a/activerecord/test/associations_test.rb b/activerecord/test/associations_test.rb index e67880681c..d0a80a0f0f 100755 --- a/activerecord/test/associations_test.rb +++ b/activerecord/test/associations_test.rb @@ -1782,4 +1782,19 @@ class HasAndBelongsToManyAssociationsTest < Test::Unit::TestCase assert_equal projects(:active_record), developer.projects[0] assert_equal projects(:action_controller), developer.projects[1] end + + # this bug highlights an issue in postgresql. fixed in edge, but i had to rollback in [5265]. + def test_select_limited_ids_list + # Set timestamps + Developer.transaction do + Developer.find(:all, :order => 'id').each_with_index do |record, i| + record.update_attributes(:created_at => 5.years.ago + (i * 5.minutes)) + end + end + + join_base = ActiveRecord::Associations::ClassMethods::JoinDependency::JoinBase.new(Project) + join_dep = ActiveRecord::Associations::ClassMethods::JoinDependency.new(join_base, :developers, nil) + projects = Project.send(:select_limited_ids_list, {:order => 'developers.created_at'}, join_dep) + assert_equal "'1', '2'", projects + end end -- cgit v1.2.3