From d98102d1d62c0862300100e32fc1e249855d4b7b Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 4 Jun 2009 09:45:10 +0000 Subject: - Patch #473876 by Berdir: fixed broken query on PostgreSQL. --- modules/simpletest/tests/database_test.test | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'modules/simpletest/tests/database_test.test') diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index e5d5b3fe0..7084ccf7e 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -1763,7 +1763,7 @@ class DatabaseSelectPagerDefaultTestCase extends DatabaseTestCase { $ages = $outer_query ->execute() ->fetchCol(); - $this->assertEqual($ages, array(25, 26, 27, 28), 'Inner pager query returned the correct ages.'); + $this->assertEqual($ages, array(25, 26, 27, 28), t('Inner pager query returned the correct ages.')); } /** @@ -1774,15 +1774,16 @@ class DatabaseSelectPagerDefaultTestCase extends DatabaseTestCase { function testHavingPagerQuery() { $query = db_select('test', 't')->extend('PagerDefault'); $query - ->fields('t', array('age')) - ->orderBy('age') - ->having('COUNT(age) > :count', array(':count' => 1)) + ->fields('t', array('name')) + ->orderBy('name') + ->groupBy('name') + ->having('MAX(age) > :count', array(':count' => 26)) ->limit(5); $ages = $query ->execute() ->fetchCol(); - $this->assertEqual($ages, array(25), ' pager query with having expression returned the correct ages.'); + $this->assertEqual($ages, array('George', 'Ringo'), t('Pager query with having expression returned the correct ages.')); } } -- cgit v1.2.3