Ensure copy table test runs for sqlite and sqlite3. [mislav] Cllosoes #8328

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6721 5ecf4fe2-1ee6-0310-87b1-e25e094e27de

1 files changed, 4 insertions, 3 deletions

diff --git a/activerecord/test/copy_table_sqlite.rb b/activerecord/test/copy_table_test_sqlite.rb
index f3f5f1ce46..6da041522f 100644
--- a/activerecord/test/copy_table_sqlite.rb
+++ b/activerecord/test/copy_table_test_sqlite.rb
@@ -26,8 +26,9 @@ class CopyTableTest < Test::Unit::TestCase
   def test_copy_table_renaming_column
     test_copy_table('companies', 'companies2', 
         :rename => {'client_of' => 'fan_of'}) do |from, to, options|
-      assert_equal column_values(from, 'client_of').compact.sort, 
-                   column_values(to, 'fan_of').compact.sort
+      expected = column_values(from, 'client_of')
+      assert expected.any?, 'only nils in resultset; real values are needed'
+      assert_equal expected, column_values(to, 'fan_of')
     end
   end
   
@@ -51,7 +52,7 @@ protected
   end
   
   def column_values(table, column)
-    @connection.select_all("SELECT #{column} FROM #{table}").map {|row| row[column]}
+    @connection.select_all("SELECT #{column} FROM #{table} ORDER BY id").map {|row| row[column]}
   end
 
   def table_indexes_without_name(table)