[Mono-bugs] [Bug 382589] New: Passing either Decimal.Max or Decimal. Min to a SQL Server 2005 stored procedure that takes a decimal(29, 0) results in a SqlException

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=382589


           Summary: Passing either Decimal.Max or Decimal.Min to a SQL
                    Server 2005 stored procedure that takes a decimal(29,0)
                    results in a SqlException
           Product: Mono: Class Libraries
           Version: 1.9.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: P5 - None
         Component: Sys.Data.SqlClient
        AssignedTo: mono-bugs at lists.ximian.com
        ReportedBy: jfrayne at blizzard.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---


System.Data.SqlClient.SqlCommand cmd;
System.Data.SqlClient.SqlParameter pValue;
..
pValue = new SqlParameter("@value", Decimal.Max);
cmd.Parameters.Add(pValue);
cmd.ExecuteNonQuery();

System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
remote procedure call (RPC) protocol stream is incorrect.
Parameter 1 ("@value"): The supplied value is not a valid instance of data type
decimal.
Check the source data for invalid values. An example of an invalid value is
data of numeric type with scale greater than precision.
  at System.Data.SqlClient.SqlConnection.ErrorHandler (System.Object sender,
Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e) [0x00000]
  at Mono.Data.Tds.Protocol.Tds.OnTdsErrorMessage
(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e) [0x00000]
  at Mono.Data.Tds.Protocol.Tds.ProcessMessage (TdsPacketSubType subType)
[0x00000]
  at Mono.Data.Tds.Protocol.Tds.ProcessSubPacket () [0x00000]
  at Mono.Data.Tds.Protocol.Tds.NextResult () [0x00000]
  at (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:NextResult
()
  at Mono.Data.Tds.Protocol.Tds.SkipToEnd () [0x00000]
  at (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds:SkipToEnd
()
  at Mono.Data.Tds.Protocol.Tds70.ExecRPC (System.String rpcName,
Mono.Data.Tds.TdsMetaParameterCollection parameters, Int32 timeout, Boolean
wantResults) [0x00000]
  at Mono.Data.Tds.Protocol.Tds70.ExecProc (System.String commandText,
Mono.Data.Tds.TdsMetaParameterCollection parameters, Int32 timeout, Boolean
wantResults) [0x00000]
  at System.Data.SqlClient.SqlCommand.Execute (CommandBehavior behavior,
Boolean wantResults) [0x00000]
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery () [0x00000]


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.