#34625 [NEW]: Scrollable cursor doesn't work with MySQL

From: stewey at ambitious dot ca Operating system: Mac OS X 10.4.2 PHP version: 5.1.0RC1 PHP Bug Type: PDO related Bug description: Scrollable cursor doesn't work with MySQL Description: ------------ Preparing a statement with the PDO_ATTR_CURSOR => PDO_CURSOR_SCROLL driver option doesn't work with MySQL. Reproduce code: --------------- $PDO = new PDO( "mysql:dbname=test;host=127.0.0.1", 'user', 'pass' ); $statement = $PDO->prepare("select id from table", array(PDO_ATTR_CURSOR => PDO_CURSOR_SCROLL) ); $statement->execute(); print_r($statement->fetch( PDO_FETCH_ASSOC, PDO_FETCH_ORI_ABS, 1 )); print_r($statement->fetch( PDO_FETCH_ASSOC, PDO_FETCH_ORI_ABS, 1 )); exit; Expected result: ---------------- I would expect to see the same row output twice. If this is not a support driver option, then I would expect and error or exception thrown (yes, exceptions are enabled). Actual result: -------------- Two different rows. The PDO_FETCH_ORI_ABS arguments are seemingly ignored. -- Edit bug report at http://bugs.php.net/?id=34625&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34625&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34625&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34625&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=34625&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=34625&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34625&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34625&r=needscript Try newer version: http://bugs.php.net/fix.php?id=34625&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34625&r=support Expected behavior: http://bugs.php.net/fix.php?id=34625&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34625&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34625&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=34625&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34625&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=34625&r=dst IIS Stability: http://bugs.php.net/fix.php?id=34625&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34625&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34625&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34625&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34625&r=mysqlcfg