#34727 [Asn->WFx]: nextRowset doesn't work with mysql 5 and stored procedure

ID: 34727 Updated by: iliaa@php.net Reported By: pointeau_sylvain at yahoo dot fr -Status: Assigned +Status: Wont fix Bug Type: PDO related Operating System: windows XP PHP Version: 5CVS-2005-10-05 (snap) Assigned To: wez New Comment: You need to compile pdo_mysql yourself against 5.0 libs that have this functionality. The stock mysql libs used for win32 builds do not support this feature, which is why you cannot use it. Previous Comments: ------------------------------------------------------------------------ [2005-10-05 11:02:54] sniper@php.net Assigned to the maintainer. ------------------------------------------------------------------------ [2005-10-05 10:43:56] pointeau_sylvain at yahoo dot fr I tried with php 5.05, 5.1RC1, latest snapshot of 5 and 5.1. I also take care to use the right PECL libraries. It still doesn't work. Please note that mysqli returns correctly the two result set. ------------------------------------------------------------------------ [2005-10-04 14:59:42] 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-10-04 13:27:31] pointeau_sylvain at yahoo dot fr Description: ------------ The second result set returned by the stored procedure is not displayed. Reproduce code: --------------- -- MYSQL 5 CREATE PROCEDURE SPG_PERSONS() BEGIN SELECT * FROM TEST_PERSON; SELECT 'second result'; END -- PHP / PDO $pdo = new PDO('mysql:host=localhost;dbname=test', '***', '***'); $stmt = $pdo->query('CALL SPG_PERSONS()'); do { $rowset = $stmt->fetchAll(); foreach ($rowset as $row) { echo $row[0]; echo '<br>'; } } while( $stmt->nextRowset() ); Expected result: ---------------- the results of both result set. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34727&edit=1