Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 17193 invoked from network); 29 Oct 2010 16:33:40 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 29 Oct 2010 16:33:40 -0000 Received: (qmail 5462 invoked by uid 500); 29 Oct 2010 16:33:40 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 5429 invoked by uid 500); 29 Oct 2010 16:33:40 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 5421 invoked by uid 99); 29 Oct 2010 16:33:40 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Oct 2010 16:33:40 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Oct 2010 16:33:39 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o9TGXJW7027337 for ; Fri, 29 Oct 2010 16:33:19 GMT Message-ID: <15306437.143871288369999428.JavaMail.jira@thor> Date: Fri, 29 Oct 2010 12:33:19 -0400 (EDT) From: "Dianne Richards (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Assigned: (OPENJPA-1862) Fix 2 test cases that cause failures on DB2 9.7 In-Reply-To: <24583910.143831288369879188.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/OPENJPA-1862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dianne Richards reassigned OPENJPA-1862: ---------------------------------------- Assignee: Dianne Richards > Fix 2 test cases that cause failures on DB2 9.7 > ----------------------------------------------- > > Key: OPENJPA-1862 > URL: https://issues.apache.org/jira/browse/OPENJPA-1862 > Project: OpenJPA > Issue Type: Test > Affects Versions: 2.1.0 > Environment: DB2 on Windows XP > Reporter: Dianne Richards > Assignee: Dianne Richards > Priority: Trivial > Fix For: 2.1.0 > > > Testing on DB2 version 9.7 discovered 2 test case problems: > TestSpec10_1_27 does a query with an order by of Company. It then checks the first return for a specific Division. The problem is that each Company has 2 Divisions. The expected return order is as follows: > Div Company > 1 1 > 2 1 > 3 2 > 4 2 > But, the first 2 could just as easily be (correctly according to the query): > Div Company > 2 1 > 1 1 > And, this actually happens often on DB2 9.7. So, changes need to be made to accept either. > ------------------------------------------------------------------------------------------------------------- > The second test case problem occurs with TestDetachRemove. When running the full test bucket, the following error occurred: > Table "DB2ADMIN.EntityA" has a foreign key to table "ENTITYB" that has not been generated. You must run the schema generator on all inter-related > tables at once. > But, there's no reference to EntityB in this EntityA. So, I assume it's a table with the name EntityA already existing for another test case. The EntityA in this test case needs to have a unique name associated with it using the @Table statement. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.