function DatabaseSelectPagerDefaultTestCase::testInnerPagerQuery

Confirm that a pager query with inner pager query returns valid results.

This is a regression test for #467984.

Archivo

drupal-7.x/modules/simpletest/tests/database_test.test, line 2394

Class

DatabaseSelectPagerDefaultTestCase

Código

function testInnerPagerQuery() {
  $query = db_select('test', 't')->extend('PagerDefault');
  $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.');
}