function DatabaseBasicSyntaxTestCase::testBasicConcat

7.x database_test.test DatabaseBasicSyntaxTestCase::testBasicConcat()

Test for string concatenation.

File

drupal-7.x/modules/simpletest/tests/database_test.test, line 3120

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.');
}