From 753010ac39f5442c92ec0bdd7484f0fd72ad8ac0 Mon Sep 17 00:00:00 2001 From: Rick Olson Date: Sun, 19 Mar 2006 17:42:51 +0000 Subject: add support for COUNT(DISTINCT id) queries in sqlite2 (closes #4300) [Rick Olson] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3979 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- activerecord/test/base_test.rb | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'activerecord/test') diff --git a/activerecord/test/base_test.rb b/activerecord/test/base_test.rb index d35f876002..35b00b878a 100755 --- a/activerecord/test/base_test.rb +++ b/activerecord/test/base_test.rb @@ -1095,9 +1095,7 @@ class BasicsTest < Test::Unit::TestCase assert_equal res4, res5 - unless ActiveRecord::Base.connection.raw_connection.class.name == 'SQLite::Database' - res6 = Post.count_by_sql "SELECT COUNT(DISTINCT p.id) FROM posts p, comments c WHERE p.#{QUOTED_TYPE} = 'Post' AND p.id=c.post_id" - end + res6 = Post.count_by_sql "SELECT COUNT(DISTINCT p.id) FROM posts p, comments c WHERE p.#{QUOTED_TYPE} = 'Post' AND p.id=c.post_id" res7 = nil assert_nothing_raised do res7 = Post.count(:conditions => "p.#{QUOTED_TYPE} = 'Post' AND p.id=c.post_id", -- cgit v1.2.3