OpenJPA
  1. OpenJPA
  2. OPENJPA-1862

Fix 2 test cases that cause failures on DB2 9.7

    Details

    • Type: Test Test
    • Status: Resolved
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      DB2 on Windows XP

      Description

      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.

        Activity

        Hide
        Michael Dick added a comment -

        If there's more work to be done for this issue please re-open, or open a sub task for the remaining work.

        Show
        Michael Dick added a comment - If there's more work to be done for this issue please re-open, or open a sub task for the remaining work.
        Hide
        Dianne Richards added a comment -

        Ignore the second problem - it was a local test case on my system, not a committed one.

        Show
        Dianne Richards added a comment - Ignore the second problem - it was a local test case on my system, not a committed one.

          People

          • Assignee:
            Dianne Richards
            Reporter:
            Dianne Richards
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development