public function SqlServerSelectTest::testDuplicatePlaceholders in Drupal driver for SQL Server and SQL Azure 7.2
Same name and namespace in other branches
- 7.3 tests/sqlsrv.select.test \SqlServerSelectTest::testDuplicatePlaceholders()
- 7 tests/sqlsrv.select.test \SqlServerSelectTest::testDuplicatePlaceholders()
Although per official documentation you cannot send duplicate placeholders in same query, this works in mySQL and is present in some queries, even in core, wich have not gotten enough attention.
File
- tests/
sqlsrv.select.test, line 152 - Support tests for SQL Server.
Class
- SqlServerSelectTest
- @file Support tests for SQL Server.
Code
public function testDuplicatePlaceholders() {
$query = db_select('test_task', 't');
$query
->addExpression('COUNT(task)', 'num');
$query
->where('t.task IN (:data0, :data0)', array(
':data0' => 'sleep',
));
$result = NULL;
try {
$result = $query
->execute()
->fetchField();
} catch (\Exception $err) {
}
$this
->assertEqual($result, 2, 'Returned the correct number of total rows.');
}