function DatabaseBasicSyntaxTestCase::testBasicConcat in Drupal 7

Test for string concatenation.

File

modules/simpletest/tests/database_test.test, line 3227

Class

DatabaseBasicSyntaxTestCase

Test how the current database driver interprets the SQL syntax.

Code

function testBasicConcat() {
  $result = db_query('SELECT CONCAT(:a1, CONCAT(:a2, CONCAT(:a3, CONCAT(:a4, :a5))))', array(
    ':a1' => 'This',
    ':a2' => ' ',
    ':a3' => 'is',
    ':a4' => ' a ',
    ':a5' => 'test.',
  ));
  $this
    ->assertIdentical($result
    ->fetchField(), 'This is a test.', 'Basic CONCAT works.');
}