ID: 34625
User updated by: stewey at ambitious dot ca
Reported By: stewey at ambitious dot ca
-Status: Bogus
+Status: Open
Bug Type: PDO related
Operating System: Mac OS X 10.4.2
PHP Version: 5.1.0RC1
New Comment:
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;
Previous Comments:
------------------------------------------------------------------------
[2005-09-24 20:34:24] [EMAIL PROTECTED]
All of those are expected behaviour.
(constants are now defined as class constants)
------------------------------------------------------------------------
[2005-09-24 20:28:10] stewey at ambitious dot ca
With php5-200509241630, I'm seeing a new problem that
prevents me from testing the previous problem:
PHP Warning: PDOStatement::fetch() expects parameter 1 to
be long, string given ...
The reproduce code is the same as above. I'm also seeing the
same error for calls to PDO::setAttribute. It seems there
might be a problem with the PDO constants in this build.
Suggestions? Next steps?
------------------------------------------------------------------------
[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
