[Mono-bugs] [Bug 68973][Blo] Changed - ExecuteNonQuery() returns wrong RowsAffected

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Wed, 3 Nov 2004 07:01:16 -0500 (EST)

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.


--- shadow/68973	2004-11-01 08:08:11.000000000 -0500
+++ shadow/68973.tmp.26007	2004-11-03 07:01:16.000000000 -0500
@@ -2,16 +2,16 @@
 Product: Mono: Class Libraries
 Version: unspecified
 OS: Windows XP
 OS Details: German XP Professional / German locales
 Status: NEW   
+Severity: Unknown
 Priority: Blocker
 Component: Sys.Data.SqlClient
-AssignedTo: rodrigo@novell.com                            
+AssignedTo: sumadevi@novell.com                            
 ReportedBy: ph_knecht@yahoo.com               
 QAContact: mono-bugs@ximian.com
 TargetMilestone: ---
 Summary: ExecuteNonQuery() returns wrong RowsAffected 
@@ -93,6 +93,19 @@
 How often does this happen? 
 Additional Information:
 don't hesitate to ask me further questions it wasn't so easy to discover
 this one.
+------- Additional Comments From sumadevi@novell.com  2004-11-03 07:01 -------
+  I tried your sample program and I am getting the same results on
+MS.NET also. Infact it is the correct behaviour where it returns the
+number of rows updated, which is 1.
+So the expected results are 14,1
+Which is what I get on both .NET and Mono.
+Also the executenonquery is supposed to return -1 for anyother type of
+statement except DELETE, INSERT or UPDATE, where it returns the