db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6772) intermittent test failure in LangScripts schemas
Date Tue, 18 Nov 2014 22:23:33 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Myrna van Lunteren updated DERBY-6772:
--------------------------------------
    Attachment: DERBY-6772.diff

attaching a patch which makes the affected query return the rows in a fixed order.

> intermittent test failure in LangScripts schemas
> ------------------------------------------------
>
>                 Key: DERBY-6772
>                 URL: https://issues.apache.org/jira/browse/DERBY-6772
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.12.0.0
>         Environment: windows 2008, ibm 1.7
>            Reporter: Myrna van Lunteren
>         Attachments: DERBY-6772.diff
>
>
> I saw a failure in LangScripts schemas.sql on a trunk test run on windows 2008 with ibm
1.7:
> {noformat}
> 1) schemas(org.apache.derbyTesting.functionTests.tests.lang.LangScripts)junit.framework.ComparisonFailure:
Output at line 477 expected:<...                   |[BTREE (1)]      > but was:<...
                  |[NULL     ]      >
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:110)
> 	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:201)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:120)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:443)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:460)
> 	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:58)
> {noformat}
> See: http://people.apache.org/~myrnavl/derby_test_results/main/windows/testSummary-1639825.html
> Without code changes this same test passed fine with other jvms.
> The diff is resulting from this query:
> {noformat}
> select schemaname, tablename, descriptor as descr
> from sys.sysschemas s, sys.sysconglomerates c , sys.systables t
> where CAST(t.tablename AS VARCHAR(128)) = 'SAMPLETAB'
>         and s.schemaid = c.schemaid
>         and c.tableid = t.tableid
> order by schemaname, tablename;
> {noformat}
> This gives three rows: In the master file (removed some spaces for display):
> {noformat}
> SCHEMANAME  |TABLENAME        |DESCR
> -------------------------------------------------------------------------
> APP                     |SAMPLETAB        |NULL
> TEST                   |SAMPLETAB        |BTREE (1)
> TEST                   |SAMPLETAB        |NULL
> {noformat}
> In the failed situation, the 'TEST' rows are ordered differently.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message