Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6968

Instability in DatabaseMetaDataTest.testGetBestRowIdentifier

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.14.1.0
    • Fix Version/s: None
    • Component/s: JDBC, Test
    • Labels:
      None
    • Urgency:
      Normal

      Description

      Ingo reports instabilities in his platform tests of the 10.14.1.0 release candidate. He sees intermittent failures in DatabaseMetaDataTest.testGetBestRowIdentifier and then subsequent failures due to poor test case isolation in that test. The test case fails because DatabaseMetaData.getBestRowIdentifier() sometimes returns rows in a different order than the test expects.

      The JDBC contract for that method does not specify an order for the returned rows. ORDER BY clauses appear on some but not all the catalog queries in metadata.properties which define the Derby result.

      I see two ways to address this issue:

      1) The test could be fixed so that it hand-sorts the returned rows in order to guarantee deterministic results.

      2) ORDER BY clauses could be added to all the implicated metadata queries.

        Attachments

        1. 10.14.1.testResults.0-failures
          29 kB
          Richard N. Hillegas
        2. derby-6968-01-aa-assertUnorderedResultSet.diff
          2 kB
          Richard N. Hillegas

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: