Test for string concatenation.

File

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

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

---