[
https://issues.apache.org/jira/browse/DERBY-5106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-5106:
--------------------------------------
Attachment: derby-5106-1a.diff
Attaching a patch that makes testJira4282 drop the table when it's done.
> 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
> Fix For: 10.8.0.0
>
> Attachments: derby-5106-1a.diff
>
>
> 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
