[DERBY-4457] 'Column value mismatch' in 'testDistinctInsertWithGeneratedColumn(...lang.DistinctTest)' on Jvm 1.5, 1.4, phoneME.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: Test

Environment

JVM:
Sun Microsystems Inc.
java version "1.5.0_14"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_14-b03)
Java HotSpot(TM) Server VM (build 1.5.0_14-b03 mixed mode 32-bit)

Sun Microsystems Inc.
java version "1.4.2_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_02-b03)
Java HotSpot(TM) Client VM (build 1.4.2_02-b03 mixed mode 32-bit)

Product: phoneME Advanced (phoneme_advanced_mr2-b116)
Profile: Foundation Profile Specification 1.1
JVM: CVM phoneme_advanced_mr2-b116 (interpreter loop)

• Bug behavior facts: Regression Test Failure
• Assignee: Knut Anders Hatlen
• Reporter: Ole Solberg
• Created: 01/Dec/09 08:25
• Updated: 17/Jun/13 09:19
• Resolved: 08/Jul/10 23:29

Description

See e.g. http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/testlog/sol/885498-suitesAll_diff.txt :

1) testDistinctInsertWithGeneratedColumn(org.apache.derbyTesting.functionTests.tests.lang.DistinctTest)junit.framework.AssertionFailedError: Column value mismatch @ column 'C12', row 1:
Expected: >1<
Found: >2<
at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1081)
at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:993)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:881)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:819)
at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:777)
at org.apache.derbyTesting.functionTests.tests.lang.DistinctTest.testDistinctInsertWithGeneratedColumn(DistinctTest.java:462)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)

Issue Links

• is related to: DERBY-4460 test_031_derby_4413 failed in nightly regression run : ComparisonFailure: expected: 1 but was: 2
• relates to: DERBY-4442 Evaluation of default value and identity in an INSERT result set evaluated too early.