From fbd6ffbf52fad02951b3f37fd3bf1341f3670830 Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Tue, 28 Dec 2010 18:49:51 +0000 Subject: #1005674 by solotandem: Fixed SelectQuery::countQuery() fails with a group by expression --- modules/simpletest/tests/database_test.test | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (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 32742e0c1..bfd67de9d 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -2033,10 +2033,13 @@ class DatabaseSelectComplexTestCase extends DatabaseTestCase { $this->assertEqual($count, 3, t('Counted the correct number of records.')); - // Test wth an alias. + // Use a column alias as, without one, the query can succeed for the wrong + // reason. $query = db_select('test_task'); $pid_field = $query->addField('test_task', 'pid', 'pid_alias'); + $query->addExpression('COUNT(test_task.task)', 'count'); $query->groupBy('pid_alias'); + $query->orderBy('pid_alias', 'asc'); $count = $query->countQuery()->execute()->fetchField(); -- cgit v1.2.3