Confirms that a paging query results with a having expression are valid.
This is a regression test for #467984.
function testHavingPagerQuery() {
$query = db_select('test', 't')
->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender');
$query
->fields('t', array(
'name',
))
->orderBy('name')
->groupBy('name')
->having('MAX(age) > :count', array(
':count' => 26,
))
->limit(5);
$ages = $query
->execute()
->fetchCol();
$this
->assertEqual($ages, array(
'George',
'Ringo',
), 'Pager query with having expression returned the correct ages.');
}