From: Date: February 29 2008 8:12pm
Subject: Connector/NET commit: r1202 - in branches/5.1: . Driver/Source
List-Archive: http://lists.mysql.com/commits/43235
X-Bug: 31338
Message-Id: <200802291912.m1TJCDxT014855@bk-internal.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modified:
   branches/5.1/CHANGES
   branches/5.1/Driver/Source/SchemaProvider.cs
Log:
Fixed problem that causes the TableAdapter wizard to only generate insert statements.  The problem was that our code to retrieve index columns was broken. (bug #31338)

Modified: branches/5.1/CHANGES
===================================================================
--- branches/5.1/CHANGES	2008-02-29 18:26:02 UTC (rev 1201)
+++ branches/5.1/CHANGES	2008-02-29 19:12:13 UTC (rev 1202)
@@ -5,7 +5,9 @@
    and cause a memory leak (bug #34338)
  - Fixed problem where attempting to use an isolation level other than the default with
    a transaction scope would use the default instead (bug #34448)
-   
+ - Fixed problem that causes the TableAdapter wizard to only generate insert statements.
+   The problem was that our code to retrieve index columns was broken. (bug #31338)
+      
 Version 5.1.5 - 
   - Fixed problem with membership provider where FindUserByEmail would fail trying to add
     a second parameter with the same name as the first (bug #33347)

Modified: branches/5.1/Driver/Source/SchemaProvider.cs
===================================================================
--- branches/5.1/Driver/Source/SchemaProvider.cs	2008-02-29 18:26:02 UTC (rev 1201)
+++ branches/5.1/Driver/Source/SchemaProvider.cs	2008-02-29 19:12:13 UTC (rev 1202)
@@ -295,7 +295,11 @@
             dt.Columns.Add("COLUMN_NAME", typeof (string));
             dt.Columns.Add("ORDINAL_POSITION", typeof (int));
 
-            DataTable tables = GetTables(restrictions);
+            string[] tableRestrictions = new string[restrictions.Length];
+            restrictions.CopyTo(tableRestrictions, 0);
+            tableRestrictions[3] = "BASE TABLE";
+            DataTable tables = GetTables(tableRestrictions);
+
             foreach (DataRow table in tables.Rows)
             {
                 string sql = String.Format("SHOW INDEX FROM `{0}`.`{1}`",