DatabaseSelectComplexTestCase::testHavingCountQuery

File

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

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, t('Counted the correct number of records.'));
}