ID: 38842
Comment by: mike at we11er dot co dot uk
Reported By: stochnagara at hotmail dot com
Status: Open
Bug Type: Feature/Change Request
Operating System: windows xp
PHP Version: 5CVS-2006-09-15 (snap)
New Comment:
Anyone?
Previous Comments:
------------------------------------------------------------------------
[2006-10-17 16:04:50] mike at we11er dot co dot uk
Err, sorry... that last error should be:
PDOStatement::execute() [function.PDOStatement-execute]:
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server
during query
------------------------------------------------------------------------
[2006-10-17 16:03:32] mike at we11er dot co dot uk
IMO this is a bug. If a stored procedure is called, it returns multiple
row sets, one for each query inside it that returns results, and one for
the return status.
Because all the results from a statement must be fetched before
subsequent statements can be made, we NEED nextRowset to work otherwise
the following error is received:
PDOStatement::nextRowset() [function.PDOStatement-nextRowset]:
SQLSTATE[HYC00]: Optional feature not implemented
closeCursor() does not work when multiple rowsets are present.
------------------------------------------------------------------------
[2006-09-18 07:35:53] [EMAIL PROTECTED]
"Optional feature not implemented" means this functionality is not yet
available. Which in turn means it's feature request.
------------------------------------------------------------------------
[2006-09-18 06:35:02] stochnagara at hotmail dot com
Sorry, this is not a feature request but a PDO related bug.
------------------------------------------------------------------------
[2006-09-15 11:20:21] stochnagara at hotmail dot com
Description:
------------
Calling nextRowset on PDOStatement generates an error.
Reproduce code:
---------------
$pdo = new PDO ('mysql:...');
$q = $pdo->query ("CALL some_proc");
$q->nextRowset();
or for example
$pdo = new PDO ('mysql:...');
$q = $pdo->query ("SELECT 1; SELECT 2;");
$q->nextRowset();
Expected result:
----------------
No errors.
Actual result:
--------------
Fatal error: Uncaught exception 'PDOException' with message
'SQLSTATE[HYC00]: Optional feature not implemented' in ...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38842&edit=1
