function QueryTest::testNumericExpressionSubstitution

Tests numeric query parameter expansion in expressions.

See also

\Drupal\sqlite\Driver\Database\sqlite\Statement::getStatement()

http://bugs.php.net/bug.php?id=45259

File

core/tests/Drupal/KernelTests/Core/Database/QueryTest.php, line 141

Class

QueryTest

Tests Drupal's extended prepared statement syntax.

Namespace

Code

public function testNumericExpressionSubstitution() : void {
    $count_expected = $this->connection
        ->query('SELECT COUNT(*) + 3 FROM {test}')
        ->fetchField();
    $count = $this->connection
        ->query('SELECT COUNT(*) + :count FROM {test}', [
        ':count' => 3,
    ])
        ->fetchField();
    $this->assertEquals($count_expected, $count);
}