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

Reply via email to