[ http://issues.apache.org/jira/browse/DERBY-655?page=all ]
Mamta A. Satoor updated DERBY-655:
----------------------------------
Attachment: Derby655GetImportedKeysPatch2Codeline101.txt
After submitting my earlier patch for 10.1, I ran the derbyall and found that
there are few more masters that are getting impacted by changes to
metadata_test.java. So, I am attaching a new diff file for 10.1 codeline, named
Derby655GetImportedKeysPatch2Codeline101.txt(Commiters, please disregard
Derby655GetImportedKeysPatch1Codeline101.txt)
> 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,
> 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
