com php-src: Add Oracle syntax (Senthil): ext/pdo/tests/bug65946.phpt

From: 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'; }

« previous php.cvs (#87880) next »