function SelectPagerDefaultTest::testInnerPagerQuery

Confirms that a pager query results with an inner pager query are valid.

This is a regression test for #467984.

File

drupal/core/modules/system/lib/Drupal/system/Tests/Database/SelectPagerDefaultTest.php, line 96

Definition of Drupal\system\Tests\Database\SelectPagerDefaultTest.

Class

SelectPagerDefaultTest

Tests the pager query select extender.

Namespace

Code

function testInnerPagerQuery() {
  $query = db_select('test', 't')
    ->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender');
  $query
    ->fields('t', array(
    'age',
  ))
    ->orderBy('age')
    ->limit(5);
  $outer_query = db_select($query);
  $outer_query
    ->addField('subquery', 'age');
  $ages = $outer_query
    ->execute()
    ->fetchCol();
  $this
    ->assertEqual($ages, array(
    25,
    26,
    27,
    28,
  ), 'Inner pager query returned the correct ages.');
}