diff options
| author | Angie Byron <webchick@24967.no-reply.drupal.org> | 2010-12-28 18:49:51 +0000 |
|---|---|---|
| committer | Angie Byron <webchick@24967.no-reply.drupal.org> | 2010-12-28 18:49:51 +0000 |
| commit | fbd6ffbf52fad02951b3f37fd3bf1341f3670830 (patch) | |
| tree | 2e98cefa3005f1d871fbcf24ee866d665dd8bf35 /modules/simpletest/tests/database_test.test | |
| parent | c719b1a5b332ea1051b612c5f8ffb99e789f4589 (diff) | |
| download | brdo-fbd6ffbf52fad02951b3f37fd3bf1341f3670830.tar.gz brdo-fbd6ffbf52fad02951b3f37fd3bf1341f3670830.tar.bz2 | |
#1005674 by solotandem: Fixed SelectQuery::countQuery() fails with a group by expression
Diffstat (limited to 'modules/simpletest/tests/database_test.test')
| -rw-r--r-- | modules/simpletest/tests/database_test.test | 5 |
1 files changed, 4 insertions, 1 deletions
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(); |