You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Yip Ng <yi...@gmail.com> on 2006/11/06 20:16:41 UTC

LangScripts JUnit test fails in views.sql

Just ran all the JUnit suites in the latest *clean* trunk, there is one test
case failed in
LangScripts with views.sql.

Time: 825.078
There was 1 failure:
1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts
)junit.fram
ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW
'SV[1]
' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent
on th
...>
        at
org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon
(CanonTestCase.java:100)
        at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest
(Scr
iptTestCase.java:117)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(
BaseTestCase.java:
76)
        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)

FAILURES!!!
Tests run: 2016,  Failures: 1,  Errors: 0

Re: LangScripts JUnit test fails in views.sql

Posted by Dy...@Sun.COM.
Yip Ng <yi...@gmail.com> writes:

> Just ran all the JUnit suites in the latest *clean* trunk, there is one test
> case failed in
> LangScripts with views.sql.
>
> Time: 825.078
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts
> )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW
> 'SV[1]
> ' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent
> on th
> ...>
>        at
> org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon
> (CanonTestCase.java:100)
>        at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest
> (Scr
> iptTestCase.java:117)
>        at org.apache.derbyTesting.junit.BaseTestCase.runBare(
> BaseTestCase.java:
> 76)
>        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)

Yep, I'm seeing this, too.

-- 
dt

Re: LangScripts JUnit test fails in views.sql

Posted by Daniel John Debrunner <dj...@apache.org>.
Dyre.Tjeldvoll@Sun.COM wrote:
> Yip Ng <yi...@gmail.com> writes:
> 
>> Some observations:
>>
>> If org.apache.derbyTesting.functionTests.harness.RunTest is used to run
>> views.sql, then it have 2 newline diffs.
>>
>> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to
>> run, then the ordering of one of the outputs differs.
>>
>> I filed a jira for this: DERBY-2048
> 
> Hmm, I think this demonstrates the weakness of canon-based testing,
> regardless of the harness being used to run them. In this particlular
> case, using JUnit actually makes it more difficult since it doesn't
> show you a context diff...

Not sure JUnit makes it any more difficult, the diff the old harness 
used had its problems, and didn't produce a context diff. If I see a 
failure I use the following, where $DM is the location of the master files:

diff -c $DM views.out

Dan.



Re: LangScripts JUnit test fails in views.sql

Posted by Dy...@Sun.COM.
Yip Ng <yi...@gmail.com> writes:

> Some observations:
>
> If org.apache.derbyTesting.functionTests.harness.RunTest is used to run
> views.sql, then it have 2 newline diffs.
>
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to
> run, then the ordering of one of the outputs differs.
>
> I filed a jira for this: DERBY-2048

Hmm, I think this demonstrates the weakness of canon-based testing,
regardless of the harness being used to run them. In this particlular
case, using JUnit actually makes it more difficult since it doesn't
show you a context diff...

-- 
dt


Re: LangScripts JUnit test fails in views.sql

Posted by Yip Ng <yi...@gmail.com>.
Some observations:

If org.apache.derbyTesting.functionTests.harness.RunTest is used to run
views.sql, then it have 2 newline diffs.

If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to
run, then the ordering of one of the outputs differs.

I filed a jira for this: DERBY-2048

Regards,
Yip Ng

Re: LangScripts JUnit test fails in views.sql

Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
Yip Ng <yi...@gmail.com> writes:

> Just ran all the JUnit suites in the latest *clean* trunk, there is one test
> case failed in
> LangScripts with views.sql.
>
> Time: 825.078
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts
> )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW
> 'SV[1]
> ' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent
> on th
> ...>
>        at
> org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon
> (CanonTestCase.java:100)
>        at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest
> (Scr
> iptTestCase.java:117)
>        at org.apache.derbyTesting.junit.BaseTestCase.runBare(
> BaseTestCase.java:
> 76)
>        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)
>
> FAILURES!!!
> Tests run: 2016,  Failures: 1,  Errors: 0

It fails in the Tinderbox test too:
http://dbtg.thresher.com/derby/test/tinderbox_trunk15/jvm1.5/testing/testlog/SunOS-5.10_i86pc-i386/471459-org.apache.derbyTesting.functionTests.suites.All_diff.txt

-- 
Knut Anders