[ 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
