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-5106) Lacking cleanup in CheckConstraintTest.testJira4282()
Date Tue, 08 Mar 2011 16:00:59 GMT
Lacking cleanup in CheckConstraintTest.testJira4282()
-----------------------------------------------------

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


The test case testJira4282 in CheckConstraintTest doesn't drop the table it creates. The table
itself has a unique name that doesn't conflict with any other test case, but it also has a
constraint with a generic name (CK1) that is in conflict with constraints created in testCheckConstraints
and testPositionalUpdate. If testJira4282 runs before any of those test cases, the test will
fail.

Example from the nightly tests:

http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/lin/1076682-suitesAll_diff.txt

1) testCheckConstraints(org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest)java.sql.SQLException:
Constraint 'CK1' already exists in Schema 'APP'.
	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
	at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
	at org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest.testCheckConstraints(CheckConstraintTest.java:243)

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

Mime
View raw message