function DatabaseSelectComplexTestCase::testHavingCountQuery in Drupal 7

File

modules/simpletest/tests/database_test.test, line 2192

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.');
}