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

ID: 34727 User updated by: pointeau_sylvain at yahoo dot fr Reported By: pointeau_sylvain at yahoo dot fr Status: Wont fix Bug Type: PDO related Operating System: windows XP PHP Version: 5CVS-2005-10-05 (snap) Assigned To: wez New Comment: Please could you describe a bit how to compile the sources under windows ? I didn't find any makefile in PDO_MYSQL-1.0RC1.tgz. The compiler is MSVC or could be mingw ? Is it possible to have to link against 5.0 libs in the next release / snapshot / delivery ? Thanks, Sylvain Previous Comments: ------------------------------------------------------------------------ [2005-10-19 17:17:33] iliaa@php.net 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. ------------------------------------------------------------------------ [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