function ReservedWordTest::testGroupBy

Tests SELECT query with GROUP BY clauses on fields with reserved names.

File

core/tests/Drupal/KernelTests/Core/Database/ReservedWordTest.php, line 86

Class

ReservedWordTest

Tests queries that include reserved words.

Namespace

Code

public function testGroupBy() {
    $this->connection
        ->insert('select')
        ->fields([
        'id' => 2,
        'update' => 'Update value 1',
    ])
        ->execute();
    // Using aliases.
    $query = $this->connection
        ->select('select', 's');
    $query->addExpression('COUNT([id])', 'num');
    $query->addField('s', 'update');
    $query->groupBy('s.update');
    $this->assertSame('2', $query->execute()
        ->fetchAssoc()['num']);
    // Not using aliases.
    $query = $this->connection
        ->select('select');
    $query->addExpression('COUNT([id])', 'num');
    $query->addField('select', 'update');
    $query->groupBy('update');
    $this->assertSame('2', $query->execute()
        ->fetchAssoc()['num']);
}