From: <su...@us...> - 2009-08-16 17:37:32
|
Revision: 3240 http://tora.svn.sourceforge.net/tora/?rev=3240&view=rev Author: subik Date: 2009-08-16 17:37:19 +0000 (Sun, 16 Aug 2009) Log Message: ----------- fixed #2815244 Repeating references in Schema Browser Modified Paths: -------------- trunk/tora/src/tobrowsertablewidget.cpp Modified: trunk/tora/src/tobrowsertablewidget.cpp =================================================================== --- trunk/tora/src/tobrowsertablewidget.cpp 2009-08-16 17:17:23 UTC (rev 3239) +++ trunk/tora/src/tobrowsertablewidget.cpp 2009-08-16 17:37:19 UTC (rev 3240) @@ -216,11 +216,13 @@ " sys.all_cons_columns r,\n" " sys.all_cons_columns c\n" " WHERE a.constraint_type = 'R'\n" - " AND a.r_constraint_name IN ( SELECT b.constraint_name\n" - " FROM sys.all_constraints b\n" - " WHERE b.OWNER = :owner<char[101]>\n" - " AND b.TABLE_NAME = :tab<char[101]> )\n" + " AND (a.r_owner, a.r_constraint_name) IN ( SELECT b.owner, b.constraint_name\n" + " FROM sys.all_constraints b\n" + " WHERE b.OWNER = :owner<char[101]>\n" + " AND b.TABLE_NAME = :tab<char[101]> )\n" + " AND a.r_owner = r.owner\n" " AND a.r_constraint_name = r.constraint_name\n" + " AND a.owner = c.owner\n" " AND a.constraint_name = c.constraint_name\n" " UNION SELECT owner,\n" " name,\n" This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |