[
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)
