[ http://issues.apache.org/jira/browse/DERBY-655?page=all ]
Deepa Remesh updated DERBY-655:
-------------------------------
Attachment: keys_test.zip
Attaching a zip file with the databases
> 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
> Priority: Minor
> Attachments: 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
