[ http://issues.apache.org/jira/browse/DERBY-655?page=comments#action_12415097 ]
Knut Anders Hatlen commented on DERBY-655: ------------------------------------------ Thanks Mamta! Committed revision 412320. > getImportedKeys returns duplicate rows in some cases > ---------------------------------------------------- > > Key: DERBY-655 > URL: http://issues.apache.org/jira/browse/DERBY-655 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.2.0.0 > Environment: Sun JDK 1.4.2, Windows XP > Reporter: Deepa Remesh > Assignee: Mamta A. Satoor > Attachments: Derby655GetImportedKeysPatch1.txt, > Derby655GetImportedKeysPatch1Codeline101.txt, > Derby655GetImportedKeysPatch1CodelineTrunk.txt, > Derby655GetImportedKeysPatch1CodelineTrunkUpgradeTest.txt, > Derby655GetImportedKeysPatch2Codeline101.txt, > Derby655GetImportedKeysStat1.txt, bigdb.sql, keys.java, keys_test.zip, > smalldb.sql > > I have a database with a large number of tables. I get duplicate rows when I > call DatabaseMetaData.getImportedKeys for a particular table. However, if I > create the same table with same number of foreign keys in another database > (which has fewer number of tables), then getImportedKeys returns me the > correct number of rows. This error seems to happen only when the database has > a large number of tables. I will attach a repro for this shortly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
