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)

Reply via email to