php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #32882 Stored Procedure spoils connection
Submitted: 2005-04-29 02:45 UTC Modified: 2005-05-03 13:20 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: sales at girderboot dot com Assigned:
Status: Not a bug Package: MySQLi related
PHP Version: 5CVS-2005-04-29 OS: Windows Server 2003
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sales at girderboot dot com
New email:
PHP Version: OS:

 

 [2005-04-29 02:45 UTC] sales at girderboot dot com
Description:
------------
After executing a query using a stored procedure that returns a result set, no futher queries can be executed.

SProc's that don't return a result set, or embedded SQL queries are not affected (but even they still cannot run after a SP with a result set is run.)

MySQL and PHP both version 5.0.4

Reproduce code:
---------------
$db = new mysqli('localhost','xxx','xxx','campnet');
	
if (!$exec = $db->query("CALL Acct_Bal(1)"))
		echo $db->error;
	$balance = $exec->fetch_row();
	
	$exec->close();
	
	echo $balance[0];
	echo "<BR>";
// Second Time
	if (!$exec = $db->query("CALL Acct_Bal(1)"))
		echo $db->error;
	$balance = $exec->fetch_row();
	
	$exec->close();
	
		echo $balance[0];

Expected result:
----------------
Should Output the same result Twice (In this case, the accout balance):


0.00
0.00

Actual result:
--------------
0.00
Lost connection to MySQL server during query
Fatal error: Call to a member function fetch_row() on a non-object in C:\Program Files\Apache Group\Apache2\htdocs\driver.php on line 40

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-04-29 03:08 UTC] sales at girderboot dot com
Upgraded to latest CVS [5.1.0-dev, Apr 26 2005 04:15:08 ]

Still same Problem.
 [2005-05-03 09:18 UTC] georg@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

Stored procedures can return more than one resultset, e.g. 
 
CREATE PROCEDURE foo() 
BEGIN 
  SELECT 'foo' FROM DUAL; 
  SELECT 'bar' FROM DUAL; 
END 
 
therefore you should handle resultsets like in 
mysqli_multi_query (calling mysqli_next_result to clear 
remaining data on socket). 
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Nov 23 12:01:29 2024 UTC