'testRunTimeStatistics(org.apache.derbyTesting.functionTests.tests.lang.OffsetFetchNextTest)junit.framework.AssertionFailedError' on Windows

• Key: DERBY-4096
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Dag H. Wanvik
• Reporter: Ole Solberg
• Component/s: Test
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.1.1

Description

See e.g.
http://dbtg.thresher.com/derby/test/Daily/jvm1.6/testing/Limited/testSummary-754693.html
http://dbtg.thresher.com/derby/test/Daily/jvm1.5/testing/Limited/testSummary-754693.html
http://dbtg.thresher.com/derby/test/Daily/jvm1.4/testing/Limited/testSummary-754693.html

There were 2 failures:
1) testRunTimeStatistics(org.apache.derbyTesting.functionTests.tests.lang.OffsetFetchNextTest)junit.framework.AssertionFailedError
at org.apache.derbyTesting.functionTests.tests.lang.OffsetFetchNextTest.testRunTimeStatistics(OffsetFetchNextTest.java:605)
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:105)
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 org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
2) testRunTimeStatistics(org.apache.derbyTesting.functionTests.tests.lang.OffsetFetchNextTest)junit.framework.AssertionFailedError
at org.apache.derbyTesting.functionTests.tests.lang.OffsetFetchNextTest.testRunTimeStatistics(OffsetFetchNextTest.java:605)
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:105)
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 org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
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 org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
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)

Comments

[Knut Anders Hatlen]

Both failures were caused by this assert:

        // Verify that the plan shows the filtering (2 rows of 3 seen):
        assertTrue(plan.indexOf("Row Count (1):" + nl +
                                "Number of opens = 1" + nl +
                                "Rows seen = 3" + nl +
                                "Rows filtered = 2") != -1);

My guess is that there's something wrong with the handling of newlines on some platforms.

[Dag H. Wanvik]

I suspect Knut is correct; the test parameterizes newlines to be platform dependent,
but it may be that in this case, UNIX style newlines are still being used.
I don't run on a Windows platform right now, but if that theory is correct, just replacing the "nl"
occurences with "\n" should make it work. I'll see if I can find a Windows platform and try it unless somebody beats me to it.

[Dag H. Wanvik]

Fixed this error as part of DERBY-4079, cf. patch derby-4079-fixRtStatsTest attached to that issue; resolving.