Connector/NET commit: r207 - in branches/1.0: . TestSuite

[rburnett]

Modified:
   branches/1.0/CHANGES
   branches/1.0/TestSuite/StoredProcedure.cs
Log:
Bug #16788 Only byte arrays and strings can be serialized by MySqlBinary [fixed]
This bug was fixed from a previous cset.


Modified: branches/1.0/CHANGES
===================================================================
--- branches/1.0/CHANGES	2006-03-07 22:19:05 UTC (rev 206)
+++ branches/1.0/CHANGES	2006-03-07 22:39:47 UTC (rev 207)
@@ -1,7 +1,8 @@
     Bug #16659 Can't use double quotation marks(") as password access server by Connector/NET [fixed]
     Bug #17375 CommandBuilder ignores Unsigned flag at Parameter creation [fixed]
     Bug #17749 There is no char type in MySqlDbType [fixed]
-    
+	Bug #16788 Only byte arrays and strings can be serialized by MySqlBinary [fixed]
+	
 x-xx-05 - Version 1.0.7
 
     Bugs fixed or addressed

Modified: branches/1.0/TestSuite/StoredProcedure.cs
===================================================================
--- branches/1.0/TestSuite/StoredProcedure.cs	2006-03-07 22:19:05 UTC (rev 206)
+++ branches/1.0/TestSuite/StoredProcedure.cs	2006-03-07 22:39:47 UTC (rev 207)
@@ -669,5 +669,37 @@
 			Assert.AreEqual("Second record", dt.Rows[1]["name"]);
 		}
 
+		/// <summary>
+		/// Bug #16788 Only byte arrays and strings can be serialized by MySqlBinary 
+		/// </summary>
+		[Test]
+		[Category("5.0")]
+		public void Bug16788()
+		{
+			execSQL("DROP TABLE IF EXISTS Test");
+			execSQL("CREATE TABLE Test (id integer(9), state varchar(2))");
+			execSQL("CREATE PROCEDURE spTest(IN p1 integer(9), IN p2 varchar(2)) " +
+				"BEGIN " +
+				"INSERT INTO test (id, state) VALUES (p1, p2); " +
+				"END");
+			
+			MySqlCommand cmd = conn.CreateCommand();
+			cmd.CommandType = CommandType.StoredProcedure;
+			cmd.CommandText = "spTest";
+			cmd.Parameters.Add("p1", MySqlDbType.UInt16, 9);
+			cmd.Parameters["p1"].Value = 44;
+			cmd.Parameters.Add("p2", MySqlDbType.VarChar, 2);
+			cmd.Parameters["p2"].Value = "ss";
+			try
+			{
+				cmd.ExecuteNonQuery();
+			}
+			catch(Exception ex)
+			{
+				Assert.Fail(ex.Message);
+			}
+		}
+
+	
 	}
 }