Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 14590 invoked from network); 27 Oct 2005 16:19:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 27 Oct 2005 16:19:24 -0000 Received: (qmail 10730 invoked by uid 500); 27 Oct 2005 16:19:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 10637 invoked by uid 500); 27 Oct 2005 16:19:20 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 10574 invoked by uid 99); 27 Oct 2005 16:19:20 -0000 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=SPF_FAIL X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2005 09:19:18 -0700 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id C165E225 for ; Thu, 27 Oct 2005 18:18:57 +0200 (CEST) Message-ID: <299741707.1130429937789.JavaMail.jira@ajax.apache.org> Date: Thu, 27 Oct 2005 18:18:57 +0200 (CEST) From: "Deepa Remesh (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (DERBY-655) getImportedKeys returns duplicate rows in some cases Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 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