Add dblib-specific query

1 files changed, 16 insertions, 7 deletions

diff --git a/ext/pdo/tests/bug_65946.phpt b/ext/pdo/tests/bug_65946.phpt
index 13a622ecb8..c636db5204 100644
--- a/ext/pdo/tests/bug_65946.phpt
+++ b/ext/pdo/tests/bug_65946.phpt
@@ -16,13 +16,22 @@ $db = PDOTest::factory();
 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
 $db->exec('CREATE TABLE test(id int)');
 $db->exec('INSERT INTO test VALUES(1)');
-if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'firebird') {
-	$sql = 'SELECT FIRST :limit * FROM test';
-} else if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
-	//$sql = 'SELECT * FROM test FETCH FIRST :limit ROWS ONLY';  // Oracle 12c syntax
-    $sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test) a where rownum <= :limit)";
-} else {
-	$sql = 'SELECT * FROM test LIMIT :limit';
+switch ($db->getAttribute(PDO::ATTR_DRIVER_NAME)) {
+	case 'dblib':
+		// if :limit is used, the value will be quoted as '1', which is invalid syntax
+		// this is a bug, to be addressed separately from adding these tests to pdo_dblib
+		$sql = 'SELECT TOP 1 * FROM test';
+		break;
+	case 'firebird':
+		$sql = 'SELECT FIRST :limit * FROM test';
+		break;
+	case 'oci':
+		//$sql = 'SELECT * FROM test FETCH FIRST :limit ROWS ONLY';  // Oracle 12c syntax
+		$sql = "select id from (select a.*, rownum rnum from (SELECT * FROM test) a where rownum <= :limit)";
+		break;
+	default:
+		$sql = 'SELECT * FROM test LIMIT :limit';
+		break;
 }
 $stmt = $db->prepare($sql);
 $stmt->bindValue('limit', 1, PDO::PARAM_INT);