[Firebird-checkins] SF.net SVN: firebird:[54416] NETProvider/trunk/NETProvider/source/ FirebirdSql/Data/Schema/FbForeignKeyColumns.cs

[<cin...@us...>]

Revision: 54416
          http://firebird.svn.sourceforge.net/firebird/?rev=54416&view=rev
Author:   cincura_net
Date:     2012-04-26 11:39:22 +0000 (Thu, 26 Apr 2012)
Log Message:
-----------
DNET-372

Modified Paths:
--------------
    NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Schema/FbForeignKeyColumns.cs

Modified: NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Schema/FbForeignKeyColumns.cs
===================================================================
--- NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Schema/FbForeignKeyColumns.cs	2012-04-26 11:37:15 UTC (rev 54415)
+++ NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Schema/FbForeignKeyColumns.cs	2012-04-26 11:39:22 UTC (rev 54416)
@@ -53,8 +53,8 @@
 					INNER JOIN rdb$ref_constraints ref ON co.rdb$constraint_name = ref.rdb$constraint_name
 					INNER JOIN rdb$indices tempidx ON co.rdb$index_name = tempidx.rdb$index_name
 					INNER JOIN rdb$index_segments coidxseg ON co.rdb$index_name = coidxseg.rdb$index_name
-					INNER JOIN rdb$index_segments refidxseg ON coidxseg.rdb$field_position = refidxseg.rdb$field_position
-					INNER JOIN rdb$indices refidx ON refidxseg.rdb$index_name = refidx.rdb$index_name");
+					INNER JOIN rdb$indices refidx ON refidx.rdb$index_name = tempidx.rdb$foreign_key
+					INNER JOIN rdb$index_segments refidxseg ON refidxseg.rdb$index_name = refidx.rdb$index_name AND refidxseg.rdb$field_position = coidxseg.rdb$field_position");
 
 			where.Append("co.rdb$constraint_type = 'FOREIGN KEY'");
 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.