[DERBY-4908] Instability in CheckConstraintTest.testBuiltInFunctions

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.7.1.1, 10.8.1.2
• Component/s: Test
• Environment: java version "1.6.0_20"; Java(TM) SE Runtime Environment (build 1.6.0_20-b02); Oracle JRockit(R) (build R28.0.1-21-133393-1.6.0_20-20100512-2126-linux-ia32, compiled mode)
• Bug behavior facts: Regression Test Failure
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 19/Nov/10 08:51
• Updated: 19/Apr/11 12:39
• Resolved: 19/Nov/10 09:21

Description

Saw this failure once when running suites.All on the 10.7.1.0 release candidate:

1) testBuiltInFunctions(org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest)junit.framework.AssertionFailedError: Column value mismatch @ column 'TYPE', row 1:
Expected: >P<
Found: >U<
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.CheckConstraintTest.testBuiltInFunctions(CheckConstraintTest.java:752)

The failure didn't show up when I reran the test (reran both standalone and as part of suites.All).