From: rburnett
Date: October 30 2006 4:48pm
Subject: Connector/NET commit: r440 - trunk/TestSuite
List-Archive: http://lists.mysql.com/commits/14574
X-Bug: 23749
Message-Id: <200610301648.k9UGmWmQ019945@bk-internal.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modified:
   trunk/TestSuite/StoredProcedure.cs
Log:
Bug #23749 VarChar field size over 255 causes a System.OverflowException 
This bug was not present in 5.0 but I made a change to an existing test case to test this.

Modified: trunk/TestSuite/StoredProcedure.cs
===================================================================
--- trunk/TestSuite/StoredProcedure.cs	2006-10-30 16:25:45 UTC (rev 439)
+++ trunk/TestSuite/StoredProcedure.cs	2006-10-30 16:48:31 UTC (rev 440)
@@ -117,13 +117,14 @@
 
 		/// <summary>
 		/// Bug #17814  	Stored procedure fails unless DbType set explicitly
+		/// Bug #23749 VarChar field size over 255 causes a System.OverflowException 
 		/// </summary>
 		[Test]
 		public void OutputParameters()
 		{
 			// create our procedure
 			execSQL("DROP PROCEDURE IF EXISTS spCount");
-			execSQL("CREATE PROCEDURE spCount(out value VARCHAR(50), OUT intVal INT, " +
+			execSQL("CREATE PROCEDURE spCount(out value VARCHAR(350), OUT intVal INT, " +
 				"OUT dateVal TIMESTAMP, OUT floatVal FLOAT, OUT noTypeVarChar VARCHAR(20), " +
 				"OUT noTypeInt INT) " +
 				"BEGIN  SET value='42';  SET intVal=33; SET dateVal='2004-06-05 07:58:09'; " +
@@ -136,11 +137,11 @@
 			cmd.Parameters.Add(new MySqlParameter("?dateVal", MySqlDbType.Datetime));
 			cmd.Parameters.Add(new MySqlParameter("?floatVal", MySqlDbType.Float));
 			MySqlParameter vcP = new MySqlParameter();
-			vcP.ParameterName = "noTypeVarChar";
+			vcP.ParameterName = "?noTypeVarChar";
 			vcP.Direction = ParameterDirection.Output;
 			cmd.Parameters.Add(vcP);
 			MySqlParameter vcI = new MySqlParameter();
-			vcI.ParameterName = "noTypeInt";
+			vcI.ParameterName = "?noTypeInt";
 			vcI.Direction = ParameterDirection.Output;
 			cmd.Parameters.Add(vcI);
 			cmd.Parameters[0].Direction = ParameterDirection.Output;