#34625 [Opn->Asn]: Scrollable cursor doesn't work with MySQL

From: Date: Sat, 24 Sep 2005 22:58:36 +0000
Subject: #34625 [Opn->Asn]: Scrollable cursor doesn't work with MySQL
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-85553@lists.php.net to get a copy of this message 
 ID:               34625
 Updated by:       sniper@php.net
 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] sniper@php.net

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

Thread (8 messages)

« previous php.bugs (#85553) next »