[Mono-bugs] [Bug 53069][Cri] Changed - Stored proc returning more than one result set hangs

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Thu, 3 Jun 2004 03:47:08 -0400 (EDT)


Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by sumadevi@novell.com.

http://bugzilla.ximian.com/show_bug.cgi?id=53069

--- shadow/53069	2004-05-13 15:28:50.000000000 -0400
+++ shadow/53069.tmp.6814	2004-06-03 03:47:08.000000000 -0400
@@ -1,13 +1,13 @@
 Bug#: 53069
 Product: Mono: Class Libraries
 Version: unspecified
 OS: Debian Potato
 OS Details: 
-Status: NEW   
-Resolution: 
+Status: RESOLVED   
+Resolution: FIXED
 Severity: Unknown
 Priority: Critical
 Component: Sys.Data.SqlClient
 AssignedTo: sumadevi@novell.com                            
 ReportedBy: dheizer_avisi@hotmail.com               
 QAContact: mono-bugs@ximian.com
@@ -43,6 +43,44 @@
 
 Everytime
 
 Additional Information:
 
 None
+
+------- Additional Comments From sumadevi@novell.com  2004-06-03 03:47 -------
+Hello,
+  I tried with the following sample program and dont see the problem.
+I have written the sample program based on your description of the
+problem.
+
+              string com = "EXECUTE sptest";
+                        cmd = new SqlCommand(com,con);
+                        try
+                        {
+                                reader = cmd.ExecuteReader();
+
+                        while (reader.Read())
+                        {
+                                Console.WriteLine(reader.GetString(0));
+                        }
+                        if (reader.NextResult())
+                        {
+                                                                     
+                              
+                        while (reader.Read())
+                        {
+                                Console.WriteLine(reader.GetString(0));
+                        }
+
+sptest STORED PROCEDURE is defined as follows
+
+ ALTER PROCEDURE sptest
+AS
+  Select name from table1;
+  SELECT city from table2;
+RETURN
+
+
+I assume that the problem is fixed.
+Incase otherwise please let me know.
+