You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <de...@db.apache.org> on 2006/05/08 22:40:22 UTC

[jira] Updated: (DERBY-655) getImportedKeys returns duplicate rows in some cases

     [ http://issues.apache.org/jira/browse/DERBY-655?page=all ]

Mamta A. Satoor updated DERBY-655:
----------------------------------

    Assign To: Mamta A. Satoor
     Priority: Major  (was: Minor)

> 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: 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