function SelectGetRangeTest::testGetRangeReferenceOnSelect

Ensures getRange() returns NULL by default.

File

core/tests/Drupal/KernelTests/Core/Database/SelectGetRangeTest.php, line 25

Class

SelectGetRangeTest

Tests SelectInterface::getRange().

Namespace

Code

public function testGetRangeReferenceOnSelect() : void {
  $raw = $this->connection
    ->select('test', 't')
    ->fields('t', [
    'name',
  ])
    ->orderBy('name')
    ->execute()
    ->fetchCol();
  $query = $this->connection
    ->select('test', 't')
    ->fields('t', [
    'name',
  ])
    ->orderBy('name');
  $range =& $query->getRange();
  $this->assertNull($range);
  $query->range(1, 3);
  $this->assertSame([
    'start' => 1,
    'length' => 3,
  ], $query->getRange());
  $range2 =& $query->getRange();
  $range2['start'] = 2;
  $this->assertEquals(2, $range['start']);
  $names = $query->execute()
    ->fetchCol();
  $expected = array_slice($raw, 2, 3);
  $this->assertSame($expected, $names);
}