[ https://issues.apache.org/jira/browse/DERBY-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-6968: --------------------------------- Attachment: derby-6968-01-aa-assertUnorderedResultSet.diff Attaching derby-6968-01-aa-assertUnorderedResultSet.diff. This patch changes the result set verifiers in DatabaseMetaDataTest.getBestRowIdentifier() to call JDBC.assertUnorderedResultSet(). The test runs cleanly for me--but then it ran cleanly for me without the patch too. The upgrade tests also ran cleanly, using 10.14.1.0 as the starting point. I will run full regression tests. Touches the following file: M java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/DatabaseMetaDataTest.java > Instability in DatabaseMetaDataTest.testGetBestRowIdentifier > ------------------------------------------------------------ > > Key: DERBY-6968 > URL: https://issues.apache.org/jira/browse/DERBY-6968 > Project: Derby > Issue Type: Bug > Components: JDBC, Test > Affects Versions: 10.14.1.0 > Reporter: Rick Hillegas > Attachments: 10.14.1.testResults.0-failures, > derby-6968-01-aa-assertUnorderedResultSet.diff > > > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)