com php-src: Add Oracle syntax (Senthil): ext/pdo/tests/bug65946.phpt
| From: | Christopher Jones | Date: | Thu, 09 Jul 2015 23:47:45 +0000 |
| Subject: | com php-src: Add Oracle syntax (Senthil): ext/pdo/tests/bug65946.phpt | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-87880@lists.php.net to get a copy of this message | ||
Commit: a3c54dd1b705878ec520e2f649f8edc760759fb5
Author: Christopher Jones <christopher.jones@oracle.com> Fri, 10 Jul 2015 09:47:45
+1000
Parents: a49ce7bb91bec02d6f26b3118404371df23242fe
Branches: master
Link: http://git.php.net/?p=php-src.git;a=commitdiff;h=a3c54dd1b705878ec520e2f649f8edc760759fb5
Log:
Add Oracle syntax (Senthil)
Changed paths:
M ext/pdo/tests/bug65946.phpt
Diff:
diff --git a/ext/pdo/tests/bug65946.phpt b/ext/pdo/tests/bug65946.phpt
index 4b63a14..af6088c 100644
--- a/ext/pdo/tests/bug65946.phpt
+++ b/ext/pdo/tests/bug65946.phpt
@@ -18,6 +18,9 @@ $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';
}