From dcb47ed24d54665f87ce61bb1f8dc9761a9f219b Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Wed, 17 Feb 2010 05:24:53 +0000 Subject: #706248 by bellHead and Damien Tournoud: Fixed field_sql_storage_field_storage_query() with 'count' option breaks on PostgreSQL and SQLite. (with tests) --- modules/simpletest/tests/database_test.test | 13 +++++++++++++ 1 file changed, 13 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 19ecbe6e9..cf569f7cc 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -1908,6 +1908,19 @@ class DatabaseSelectComplexTestCase extends DatabaseTestCase { $this->assertEqual($count, 4, t('Counted the correct number of records.')); } + /** + * Test that we can generate a count query from a query with distinct. + */ + function testCountQueryDistinct() { + $query = db_select('test_task'); + $task_field = $query->addField('test_task', 'task'); + $query->distinct(); + + $count = $query->countQuery()->execute()->fetchField(); + + $this->assertEqual($count, 6, t('Counted the correct number of records.')); + } + /** * Confirm that we can properly nest conditional clauses. */ -- cgit v1.2.3