function QueryTest::testNumericExpressionSubstitution

Tests numeric query parameter expansion in expressions.

See also

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

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

File

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

Class

QueryTest

Tests Drupal's extended prepared statement syntax..

Namespace

Code

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