[Mono-bugs] [Bug 76543][Wis] Changed - Mono.Data.Sqlite.ExecuteScalar(): select count(*) cannot be cast to int?

bugzilla-daemon at bugzilla.ximian.com bugzilla-daemon at bugzilla.ximian.com
Mon Jan 2 15:47:04 EST 2006

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 tauberer at for.net.


--- shadow/76543	2005-12-01 15:58:54.000000000 -0500
+++ shadow/76543.tmp.3543	2006-01-02 15:47:04.000000000 -0500
@@ -1,14 +1,14 @@
 Bug#: 76543
 Product: Mono: Class Libraries
 Version: 1.0
+OS: unknown
 OS Details: 
-Status: NEW   
+Status: RESOLVED   
+Resolution: NOTABUG
+Severity: Unknown
 Priority: Wishlist
 Component: Sys.Data
 AssignedTo: tsenganal at novell.com                            
 ReportedBy: tekhedd at byteheaven.net               
 QAContact: mono-bugs at ximian.com
 TargetMilestone: ---
@@ -49,6 +49,12 @@
 Additional Information:
 This is undoubtedly a side effect of the type-neutral nature of sqlite's
 internal tables. It probably isn't worth panicking over, as
 Convert.ToInt32( cmd.executeReader()) works every time, but the overhead
 seems wasteful.
+------- Additional Comments From tauberer at for.net  2006-01-02 15:47 -------
+Sqlite doesn't track the types of expressions, and there's no way to
+know that the returned value, a string or long, was supposed to be an
+integer.  You should use GetInt32() on the data reader to ensure you
+get something of the right type.

More information about the mono-bugs mailing list