Rick Hillegas created DERBY-6441:
------------------------------------
Summary: Non-deterministic query results in GrantRevokeDDLTest
Key: DERBY-6441
URL: https://issues.apache.org/jira/browse/DERBY-6441
Project: Derby
Issue Type: Bug
Components: Test
Reporter: Rick Hillegas
The lack of an ORDER BY clause on a query in
GrantRevokeDDLTest.getGrantRevokeDDL can give rise to errors like the following
(seen in test run
http://javadb.se.oracle.com/javadb-testing/request_5586034/javadb-task-3781856.html):
junit.framework.AssertionFailedError: Column value mismatch @ column
'SCHEMANAME', row 4:
Expected: >SATHEESH<
Found: >TEST_DBO<
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1291)
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1203)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1090)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1013)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:970)
at
org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest.testGrantRevokeDDL(GrantRevokeDDLTest.java:451)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:118)
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:440)
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:457)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)