From: Date: May 21 2007 4:51pm
Subject: Connector/NET commit: r729 - trunk/TestSuite/Source
List-Archive: http://lists.mysql.com/commits/27075
X-Bug: 28448
Message-Id: <200705211451.l4LEpiHZ004434@bk-internal.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modified:
   trunk/TestSuite/Source/Syntax.cs
Log:
Bug #28448  	show processlist; returns byte arrays in the resulting data table

This was already fixed in 5.0.7 and merged so no cset here.  The problem did exist in 5.1.0 however.

Modified: trunk/TestSuite/Source/Syntax.cs
===================================================================
--- trunk/TestSuite/Source/Syntax.cs	2007-05-21 14:50:24 UTC (rev 728)
+++ trunk/TestSuite/Source/Syntax.cs	2007-05-21 14:51:44 UTC (rev 729)
@@ -504,5 +504,25 @@
                 suExecSQL("DROP DATABASE `my db`");
             }
         }
+
+        /// <summary>
+        /// Bug #28448  	show processlist; returns byte arrays in the resulting data table
+        /// </summary>
+        [Test]
+        public void ShowProcessList()
+        {
+            MySqlCommand cmd = new MySqlCommand("show processlist", conn);
+            DataTable dt = new DataTable();
+
+            using (MySqlDataReader rdr = cmd.ExecuteReader())
+            {
+                dt.Load(rdr);
+            }
+            DataRow row = dt.Rows[0];
+
+            Assert.IsTrue(row["User"].GetType().Name == "String");
+            Assert.IsTrue(row["Host"].GetType().Name == "String");
+            Assert.IsTrue(row["Command"].GetType().Name == "String");
+        }
 	}
 }