[Mono-bugs] [Bug 81940][Nor] New - Various issues involving SqlTypes with SqlClient

[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 sailor at sailorfrag.net.

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

--- shadow/81940	2007-06-23 18:55:27.000000000 -0400
+++ shadow/81940.tmp.25961	2007-06-23 18:55:27.000000000 -0400
@@ -0,0 +1,137 @@
+Bug#: 81940
+Product: Mono: Class Libraries
+Version: 1.2
+OS: 
+OS Details: Ubuntu feisty
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data.SqlClient
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: sailor at sailorfrag.net               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Various issues involving SqlTypes with SqlClient
+
+Description of Problem: Various issues involving SqlTypes with SqlClient
+
+Steps to reproduce the problem:
+1. At the top of attached nunit test case (monosqltest.cs), fill in the
+hostname, username, password, and database fields. Nothing will be
+permanently stored in the database; the test only uses temporary tables.
+2. Compile the test case
+- gmcs -pkg:nunit -r:System.Data /target:library monosqltest.cs
+3. Run the test case in nunit
+- nunit-console /nologo /labels monosqltest.dll
+
+Actual Results:
+Each test case fails.
+
+Failures:
+1) MonoSqlTest.VerifyChar : 
+        expected: <8000>
+         but was: <4000>
+  at MonoSqlTest.VerifyChar () [0x00000] 
+  at <0x00000> <unknown method>
+  at (wrapper managed-to-native)
+System.Reflection.MonoMethod:InternalInvoke (object,object[])
+  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags
+invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
+System.Globalization.CultureInfo culture) [0x00000] 
+
+2) MonoSqlTest.VerifyDateTime : 
+        expected: <06/23/2007 18:16:18>
+         but was: <06/23/2007 18:16:18>
+  at MonoSqlTest.VerifyDateTime () [0x00000] 
+  at <0x00000> <unknown method>
+  at (wrapper managed-to-native)
+System.Reflection.MonoMethod:InternalInvoke (object,object[])
+  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags
+invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
+System.Globalization.CultureInfo culture) [0x00000] 
+
+3) MonoSqlTest.VerifyDecimal : 
+        String lengths differ.  Expected length=40, but was length=39.
+        Strings differ at index 0.
+        expected: <"0.999999999999999999999999999999999...">
+         but was: <".9999999999999999999999999999999999...">
+        ------------^
+  at MonoSqlTest.VerifyDecimal () [0x00000] 
+  at <0x00000> <unknown method>
+  at (wrapper managed-to-native)
+System.Reflection.MonoMethod:InternalInvoke (object,object[])
+  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags
+invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
+System.Globalization.CultureInfo culture) [0x00000] 
+
+4) MonoSqlTest.VerifyFloat : System.ArgumentException : The parameter data
+type of SqlSingle is invalid.
+  at System.Data.SqlClient.SqlParameter.InferSqlType (System.Object value)
+[0x00000] 
+  at System.Data.SqlClient.SqlParameter..ctor (System.String parameterName,
+System.Object value) [0x00000] 
+  at (wrapper remoting-invoke-with-check)
+System.Data.SqlClient.SqlParameter:.ctor (string,object)
+  at MonoSqlTest.Insert (System.String table, System.Object[] param) [0x00000] 
+  at MonoSqlTest.VerifyFloat () [0x00000] 
+  at <0x00000> <unknown method>
+  at (wrapper managed-to-native)
+System.Reflection.MonoMethod:InternalInvoke (object,object[])
+  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags
+invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
+System.Globalization.CultureInfo culture) [0x00000] 
+
+5) MonoSqlTest.VerifyMoney : 
+        expected: <-3.141>
+         but was: <1844674407370952.0206>
+  at MonoSqlTest.VerifyMoney () [0x00000] 
+  at <0x00000> <unknown method>
+  at (wrapper managed-to-native)
+System.Reflection.MonoMethod:InternalInvoke (object,object[])
+  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags
+invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
+System.Globalization.CultureInfo culture) [0x00000] 
+
+6) MonoSqlTest.VerifyXML : 
+        String lengths differ.  Expected length=70, but was length=68.
+        Strings differ at index 27.
+        expected: <"<outside><!--hi--><element1 />Text<element2
+type="pretty" /></...">
+         but was: <"<outside><!--hi--><element1/>Text<element2
+type="pretty"/></ou...">
+        ---------------------------------------^
+  at MonoSqlTest.VerifyXML () [0x00000] 
+  at <0x00000> <unknown method>
+  at (wrapper managed-to-native)
+System.Reflection.MonoMethod:InternalInvoke (object,object[])
+  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags
+invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
+System.Globalization.CultureInfo culture) [0x00000] 
+
+Expected Results:
+On Microsoft's .NET implementation, connected to MSSQL 2005, all tests pass.
+
+How often does this happen?
+Every time
+
+
+Additional Information:
+SQL Express 2005 (the free download) can be used for this.
+
+I apologize for not filing separate bugs (there appear to be 7 or so), but
+the test cases should make the problems fairly clear, and I already spent a
+substantial amount of time on this. :-)
+
+$ gmcs --version
+Mono C# compiler version 1.2.3.1
+$ mono --version
+Mono JIT compiler version 1.2.3.1, (C) 2002-2006 Novell, Inc and
+Contributors. www.mono-project.com
+        TLS:           __thread
+        GC:            Included Boehm (with typed GC)
+        SIGSEGV:       normal
+        Architecture:  x86
+        Disabled:      none