From 8cbf5a50c8cecf7e273bb034ecc6b9a77150d041 Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Thu, 23 Dec 2010 09:31:56 +0000 Subject: #1003860 follow-up by dereine, dmitrig01, chx: Fix count queries with aliases. --- modules/simpletest/tests/database_test.test | 9 +++++++++ 1 file changed, 9 insertions(+) (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 db74bd9e5..32742e0c1 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -2032,6 +2032,15 @@ class DatabaseSelectComplexTestCase extends DatabaseTestCase { $count = $query->countQuery()->execute()->fetchField(); $this->assertEqual($count, 3, t('Counted the correct number of records.')); + + // Test wth an alias. + $query = db_select('test_task'); + $pid_field = $query->addField('test_task', 'pid', 'pid_alias'); + $query->groupBy('pid_alias'); + + $count = $query->countQuery()->execute()->fetchField(); + + $this->assertEqual($count, 3, t('Counted the correct number of records.')); } /** -- cgit v1.2.3