function DatabaseSelectComplexTestCase::testHavingCountQuery

File

core/modules/simpletest/tests/database_test.test, line 2126

Database tests.

Class

DatabaseSelectComplexTestCase

Test more complex select statements.

Code

function testHavingCountQuery() {
  $query = db_select('test')
    ->extend('PagerDefault')
    ->groupBy('age')
    ->having('age + 1 > 0');
  $query->addField('test', 'age');
  $query->addExpression('age + 1');
  $count = count($query->execute()->fetchCol());
  $this->assertEqual($count, 4, 'Counted the correct number of records.');
}