[Mono-bugs] [Bug 69768][Nor] New - Mono 1.04 SqlClient will load the Sql 'bigint' as System.Decimal, not System.Int64

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Sun, 21 Nov 2004 03:51:27 -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 josephmolnar@hotmail.com.

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

--- shadow/69768	2004-11-21 03:51:27.000000000 -0500
+++ shadow/69768.tmp.23421	2004-11-21 03:51:27.000000000 -0500
@@ -0,0 +1,43 @@
+Bug#: 69768
+Product: Mono: Class Libraries
+Version: 1.0
+OS: 
+OS Details: XP SP 2
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data.SqlClient
+AssignedTo: josephmolnar@hotmail.com                            
+ReportedBy: josephmolnar@hotmail.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Mono 1.04 SqlClient will load the Sql 'bigint' as System.Decimal, not System.Int64
+
+Description of Problem:
+
+Mono 1.04 SqlClient will load the Sql 'bigint' as System.Decimal, not 
+System.Int64. I'm using an IDataReader to load from the 
+Command/Connection and the field in the DB is a 'bigint' which is a 64-
+bit value. The MS .NET SqlClient will load it as a System.Int64, where 
+Mono is loading it as System.Deciaml.
+
+Steps to reproduce the problem:
+1. Create a table in a Sql Server database with a 'bigint' field column
+1. Create a connection to a sql database.
+2. Create a command on the connection to load the 'bigint' field
+
+Actual Results:
+
+The type return for the field is a System.Decimal.
+
+Expected Results:
+
+The type return should be a System.Int64 (to remain compatible to the 
+MS .NET SqlClient)
+
+How often does this happen? 
+
+Everytime I've tried so far.