db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2048) LangScripts JUnit test fails in views.sql
Date Tue, 07 Nov 2006 03:45:37 GMT
    [ http://issues.apache.org/jira/browse/DERBY-2048?page=comments#action_12447618 ] 
            
Yip Ng commented on DERBY-2048:
-------------------------------

Just took a brief look at LangScripts, I noticed that it uses a test decorator CleanDatabaseTestSetup
which cleans up user tables only.  So for SQL scripts that perform alot of DDLs (create table,
drop table, etc.), I think this might affect the outcome of certain scripts master output,
e.g.  fetching rows from system tables in an unordered way.  This may be one reason that contribute
to the stated problem of this jira and may be problematic in general for adding future test
scripts since each testcase in the suite is not starting with an initial database state (like
the legacy way) but the database state of the previous script execution.


> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
>                 Key: DERBY-2048
>                 URL: http://issues.apache.org/jira/browse/DERBY-2048
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.3.0.0
>         Environment: Windows XP
>            Reporter: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> 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(ScriptTestCase.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
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql
as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message