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] Updated: (DERBY-655) getImportedKeys returns duplicate rows in some cases
Date Tue, 30 May 2006 17:32:31 GMT
     [ http://issues.apache.org/jira/browse/DERBY-655?page=all ]

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

    Attachment: Derby655GetImportedKeysPatch1Codeline101.txt

I tried doing merge on 10.1 codeline using following 
svn merge -r 409579:409580 https://svn.apache.org/repos/asf/db/derby/code/branches/10.0
and ran into problems with test file and master files changes. merge didn't work for test
file changes because in 10.1, we have split metadata.java into 2 classes, metadata.java and
metadata_test.java. The changes I made in 10.0 metadata.java need to go in 10.1 metadata_test.java.
I fixed this by reverting the test file and master files from the merge command and hand-doiing
the test changes. The diff for 10.1 is attached as Derby655GetImportedKeysPatch1Codeline101.txt
to this JIRA entry. Let me know if a commiter runs into a problem. Next, I will work on getting
a patch ready for main codeline. 

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