From 66d31c52ba73e2216202ab2ee45e8f29d33164ea Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sun, 8 Aug 2010 02:18:53 +0000 Subject: - Patch #423888 by mikeryan, Crell, drunken monkey: use subqueries for ->countQuery(), at least for MySQL. --- modules/simpletest/tests/database_test.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'modules/simpletest') diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index b2efa6672..e7f812893 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -1986,6 +1986,19 @@ class DatabaseSelectComplexTestCase extends DatabaseTestCase { $this->assertEqual($count, 6, t('Counted the correct number of records.')); } + /** + * Test that we can generate a count query from a query with GROUP BY. + */ + function testCountQueryGroupBy() { + $query = db_select('test_task'); + $pid_field = $query->addField('test_task', 'pid'); + $query->groupBy('pid'); + + $count = $query->countQuery()->execute()->fetchField(); + + $this->assertEqual($count, 3, t('Counted the correct number of records.')); + } + /** * Confirm that we can properly nest conditional clauses. */ -- cgit v1.2.3