ID: 34625 Updated by: [EMAIL PROTECTED] Reported By: stewey at ambitious dot ca -Status: Open +Status: Assigned Bug Type: PDO related Operating System: Mac OS X 10.4.2 -PHP Version: 5.1.0RC1 +PHP Version: 5CVS-2005-09-25 (snap) -Assigned To: +Assigned To: pdo
Previous Comments: ------------------------------------------------------------------------ [2005-09-24 23:46:32] stewey at ambitious dot ca Thanks for the info. Constant problem resolved, but the scrollable cursor problem remains. New repro 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; ------------------------------------------------------------------------ [2005-09-24 13:36:13] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-09-24 06:35:56] stewey at ambitious dot ca 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 this bug report at http://bugs.php.net/?id=34625&edit=1