db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-655) getImportedKeys returns duplicate rows in some cases
Date Fri, 30 Jun 2006 02:53:31 GMT
     [ http://issues.apache.org/jira/browse/DERBY-655?page=all ]
     
Mamta A. Satoor resolved DERBY-655:
-----------------------------------

    Fix Version: 10.2.0.0
     Resolution: Fixed

Resolving this issue since the patch ensures the uniqueness of conglomerateid for new conglomerates
in SYSCONGLOMERATES table. For existing duplicate conglomeratid, work needs to be done at
the database upgrade time. DERBY-1343 is open to track upgrade work. As per my knowledge,
nobody is working on DERBY-1343 at this point.

> 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
>      Fix For: 10.2.0.0
>  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


Mime
View raw message