[Mono-bugs] [Bug 75684][Nor] New - Inserting IMAGE values > 8000 Bytes not possible

[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 joergr at voelcker.com.

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

--- shadow/75684	2005-08-02 04:29:57.000000000 -0400
+++ shadow/75684.tmp.14343	2005-08-02 04:29:57.000000000 -0400
@@ -0,0 +1,102 @@
+Bug#: 75684
+Product: Mono: Class Libraries
+Version: 1.1
+OS: Suse 8.2
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data.SqlClient
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: JoergR at voelcker.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Summary: Inserting IMAGE values > 8000 Bytes not possible
+
+Description of Problem:
+The Mono class library is throwing an exception when we are inserting an
+IMAGE value > 8000 Bytes using a query with parameters.
+
+
+Steps to reproduce the problem:
+1. Create a test table using following statement:
+  create table ImageTest
+  (
+    uid char(38) not null,
+    img image null,
+
+    primary key (uid)
+  )
+
+2. Change connection string in attached sample
+3. Compile
+4. Run
+
+
+Actual Results:
+Exception caught: System.Data.SqlClient.SqlException: The size (9000) given
+to the type 'varbinary' exceeds the maximum allowed for any data type (8000).
+The size (9000) given to the type 'varbinary' exceeds the maximum allowed
+for any data type (8000).
+in <0x000ae> System.Data.SqlClient.SqlConnection:ErrorHandler
+(System.Object sender,
+Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e)
+in (wrapper delegate-invoke)
+System.MulticastDelegate:invoke_void_object_TdsInternalErrorMessageEventArgs
+(object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
+in <0x0001d> Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage
+(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e)
+in <0x001b2> Mono.Data.Tds.Protocol.Tds:ProcessMessage (TdsPacketSubType
+subType)
+in <0x00112> Mono.Data.Tds.Protocol.Tds:ProcessSubPacket ()
+in <0x00047> Mono.Data.Tds.Protocol.Tds:NextResult ()
+in (wrapper remoting-invoke-with-check)
+Mono.Data.Tds.Protocol.Tds:NextResult ()
+in <0x0000d> Mono.Data.Tds.Protocol.Tds:SkipToEnd ()
+in (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:SkipToEnd ()
+in <0x00099> Mono.Data.Tds.Protocol.Tds:ExecuteQuery (System.String sql,
+Int32 timeout, Boolean wantResults)
+in <0x0007a> Mono.Data.Tds.Protocol.Tds70:Execute (System.String
+commandText, Mono.Data.Tds.TdsMetaParameterCollection parameters, Int32
+timeout, Boolean wantResults)
+in <0x0031c> System.Data.SqlClient.SqlCommand:Execute (CommandBehavior
+behavior, Boolean wantResults)
+in <0x00048> System.Data.SqlClient.SqlCommand:ExecuteNonQuery ()
+in <0x00288> Bug.MainClass:Main ()
+in <0x000ae> System.Data.SqlClient.SqlConnection:ErrorHandler
+(System.Object sender,
+Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e)
+in (wrapper delegate-invoke)
+System.MulticastDelegate:invoke_void_object_TdsInternalErrorMessageEventArgs
+(object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
+in <0x0001d> Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage
+(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e)
+in <0x001b2> Mono.Data.Tds.Protocol.Tds:ProcessMessage (TdsPacketSubType
+subType)
+in <0x00112> Mono.Data.Tds.Protocol.Tds:ProcessSubPacket ()
+in <0x00047> Mono.Data.Tds.Protocol.Tds:NextResult ()
+in (wrapper remoting-invoke-with-check)
+Mono.Data.Tds.Protocol.Tds:NextResult ()
+in <0x0000d> Mono.Data.Tds.Protocol.Tds:SkipToEnd ()
+in (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:SkipToEnd ()
+in <0x00099> Mono.Data.Tds.Protocol.Tds:ExecuteQuery (System.String sql,
+Int32 timeout, Boolean wantResults)
+in <0x0007a> Mono.Data.Tds.Protocol.Tds70:Execute (System.String
+commandText, Mono.Data.Tds.TdsMetaParameterCollection parameters, Int32
+timeout, Boolean wantResults)
+in <0x0031c> System.Data.SqlClient.SqlCommand:Execute (CommandBehavior
+behavior, Boolean wantResults)
+in <0x00048> System.Data.SqlClient.SqlCommand:ExecuteNonQuery ()
+in <0x00288> Bug.MainClass:Main ()
+
+
+Expected Results:
+Data is inserted without problems.
+
+How often does this happen? 
+Always.
+
+Additional Information:
+Works on .NET Framework on Windows.