bzr commit into connector-net-trunk branch (reggie.burnett:810) Bug#48974

[Reggie Burnett]

#At file:///C:/bzr-connector-net/trunk/ based on revid:reggie.burnett@stripped

  810 Reggie Burnett	2009-12-09 [merge]
      Fixed problem caused by us not including a 'REFERENCED_TABLE_CATALOG' column in our  foreign keys collection (bug #48974)

    modified:
      CHANGES
      MySql.Data/Provider/Source/ISSchemaProvider.cs
      MySql.Data/Tests/Source/GetSchemaTests.cs
=== modified file 'CHANGES'
=== modified file 'CHANGES'
--- a/CHANGES	2009-12-09 15:10:20 +0000
+++ b/CHANGES	2009-12-09 18:38:12 +0000
@@ -3,6 +3,8 @@
 - Always close connection in MySqlConnection.Dispose(), also when it is garbage-collected
   so underlying driver can be reused in the connection pool (bug#31996)
 - Fixed precision calculation on decimal and newdecimal columns (bug #48171)
+- Fixed problem caused by us not including a 'REFERENCED_TABLE_CATALOG' column in our
+  foreign keys collection (bug #48974)
 
 Version 6.2.1
 - fixed SessionProvider to be compatible with 4.x MySQL, replaced TIMESTAMPDIFF with TIME_TO_SEC

=== modified file 'MySql.Data/Provider/Source/ISSchemaProvider.cs'
--- a/MySql.Data/Provider/Source/ISSchemaProvider.cs	2009-07-28 20:40:35 +0000
+++ b/MySql.Data/Provider/Source/ISSchemaProvider.cs	2009-12-09 18:36:12 +0000
@@ -418,6 +418,7 @@
             string sql = @"SELECT rc.constraint_catalog, rc.constraint_schema,
                 rc.constraint_name, kcu.table_catalog, kcu.table_schema, rc.table_name,
                 rc.match_option, rc.update_rule, rc.delete_rule, 
+                NULL as referenced_table_catalog,
                 kcu.referenced_table_schema, rc.referenced_table_name 
                 FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
                 LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu ON 

=== modified file 'MySql.Data/Tests/Source/GetSchemaTests.cs'
--- a/MySql.Data/Tests/Source/GetSchemaTests.cs	2009-11-25 15:16:10 +0000
+++ b/MySql.Data/Tests/Source/GetSchemaTests.cs	2009-12-09 18:38:12 +0000
@@ -459,7 +459,8 @@
 				"ON UPDATE CASCADE ON DELETE RESTRICT, INDEX (customer_id), " +
 				"FOREIGN KEY (customer_id) REFERENCES customer(id)) ENGINE=INNODB");
 
-			conn.GetSchema("Foreign Keys");
+			DataTable dt = conn.GetSchema("Foreign Keys");
+            Assert.IsTrue(dt.Columns.Contains("REFERENCED_TABLE_CATALOG"));
 		}
 
 		[Test]


Attachment: [text/bzr-bundle] bzr/[e-mail]