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

[bugzilla-daemon at bugzilla.ximian.com]

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.

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

--- 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: 
+OS: unknown
 OS Details: 
-Status: NEW   
-Resolution: 
-Severity: 
+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.