|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2020-10-02 21:36 UTC] cmb@php.net
-Status: Open
+Status: Verified
-PHP Version: 5.2.5
+PHP Version: 7.3
[2020-10-02 21:36 UTC] cmb@php.net
[2021-03-26 15:33 UTC] cmb@php.net
-Type: Bug
+Type: Documentation Problem
[2021-03-26 15:33 UTC] cmb@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Oct 28 03:00:02 2025 UTC |
Description: ------------ problem with: odbc_next_result() mysql-server: 5.0.51a (.45-the same problem) odbc driver: Driver={MySQL ODBC 3.51 Driver} when MySQL procedure returns 2 rowsets, after the second rowset odbc_next_result() returns true. Reproduce code: --------------- <?php /* mysql: CREATE PROCEDURE `multiplerowsets`() BEGIN select 'rs1'; select 'rs2'; END; */ $dsn="Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Database=db_name;"; $conn=odbc_connect($dsn,'user','passwd'); $query="call multiplerowsets"; $result=odbc_exec($conn,$query); $row=odbc_fetch_array ($result); var_dump(odbc_next_result($result)); $row=odbc_fetch_array ($result); var_dump(odbc_next_result($result)); $row=odbc_fetch_array ($result); var_dump(odbc_next_result($result)); ?> Expected result: ---------------- bool(true) bool(false) bool(false) Actual result: -------------- bool(true) bool(true) Warning: odbc_fetch_array() [function.odbc-fetch-array]: No tuples available at this result index in D:\Apache2.2\htdocs\test\x.php on line 19 bool(false)