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

     [ 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

Mime
View raw message