From df8669d4b5691646ca8bb4ba01f6e5348ae8dd69 Mon Sep 17 00:00:00 2001 From: Pratik Naik Date: Sat, 7 Mar 2009 16:36:40 +0000 Subject: Fix calculation tests to work on sqlite --- activerecord/test/cases/calculations_test.rb | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) (limited to 'activerecord/test/cases/calculations_test.rb') diff --git a/activerecord/test/cases/calculations_test.rb b/activerecord/test/cases/calculations_test.rb index 0257fe57cb..f01ac2ea39 100644 --- a/activerecord/test/cases/calculations_test.rb +++ b/activerecord/test/cases/calculations_test.rb @@ -265,14 +265,16 @@ class CalculationsTest < ActiveRecord::TestCase end def test_should_count_scoped_select - Account.update_all("credit_limit = 50") - assert_equal 1, Account.scoped(:select => "DISTINCT credit_limit").count + Account.update_all("credit_limit = NULL") + assert_equal 0, Account.scoped(:select => "credit_limit").count end def test_should_count_scoped_select_with_options - Account.update_all("credit_limit = 50") - Account.first.update_attribute('credit_limit', 49) - assert_equal 1, Account.scoped(:select => "DISTINCT credit_limit").count(:conditions => [ 'credit_limit >= 50'] ) + Account.update_all("credit_limit = NULL") + Account.last.update_attribute('credit_limit', 49) + Account.first.update_attribute('credit_limit', 51) + + assert_equal 1, Account.scoped(:select => "credit_limit").count(:conditions => ['credit_limit >= 50']) end def test_should_count_manual_select_with_include -- cgit v1.2.3