db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-5102) GrantRevokeDDLTest depends on implicit ordering of test cases
Date Tue, 08 Mar 2011 12:48:59 GMT
GrantRevokeDDLTest depends on implicit ordering of test cases
-------------------------------------------------------------

                 Key: DERBY-5102
                 URL: https://issues.apache.org/jira/browse/DERBY-5102
             Project: Derby
          Issue Type: Bug
          Components: Test
    Affects Versions: 10.8.0.0
            Reporter: Knut Anders Hatlen


If for example the test case testMinimumSelectPrivilegeRequirement runs before testGrantRevokeDDL2,
the test will fail with the following error:

4) testGrantRevokeDDL2(org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest)java.sql.SQLException:
Schema 'USER1' already exists.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:98)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:396)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:348)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2290)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1334)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:630)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:179)
        at org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest.testGrantRevokeDDL2(GrantRevokeDDLTest.java:6540)

Or, if testRevokeDropsFKWithSharedConglom runs before testGrantRevokeDDL, the test will fail
like this:

7) testGrantRevokeDDL(org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest)junit.framework.AssertionFailedError:
Column value mismatch @ column 'SCHEMANAME', row 4:
    Expected: >SATHEESH<
    Found:    >MAMTA1<
	at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1213)
	at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1125)
	at org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1012)
	at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:935)
	at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:892)
	at org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest.testGrantRevokeDDL(GrantRevokeDDLTest.java:397)

The test should either make the order of the test cases explicit or make the test cases independent
of the order in which they run.

Seen in the nightly tests, for example here: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/lin/1076682-suitesAll_diff.txt

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message