db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-655) getImportedKeys returns duplicate rows in some cases
Date Thu, 27 Oct 2005 16:22:56 GMT
     [ http://issues.apache.org/jira/browse/DERBY-655?page=all ]

Deepa Remesh updated DERBY-655:
-------------------------------

    Attachment: keys.java
                bigdb.sql
                smalldb.sql

Attaching a repro for this. To see the problem:

1. Start ij and run bigdb.sql and smalldb.sql. It will create 2 databases bigdb and smalldb.
Since it takes a while to run the sql, I will also attach a zip file with the databases already
created. 
2. Run "java keys smalldb". Call to getImportedKeys for the table 'ACCCMDGRP' returns 2 rows,
which is correct.
3. Run "java keys bigdb". Call to getImportedKeys for the table 'ACCCMDGRP' returns 3 rows
instead of 2. In the output, rows 2 and 3 are duplicates.


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