function DatabaseBasicSyntaxTestCase::testConcatWsFields

Tests string concatenation with separator, with field values.

File

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

Database tests.

Class

DatabaseBasicSyntaxTestCase

Test how the current database driver interprets the SQL syntax.

Code

function testConcatWsFields() {
  $result = db_query("SELECT CONCAT_WS('-', :a1, name, :a2, age) FROM {test} WHERE age = :age", array(
    ':a1' => 'name',
    ':a2' => 'age',
    ':age' => 25,
  ));
  $this->assertIdentical($result->fetchField(), 'name-John-age-25');
}