[ 
https://issues.apache.org/jira/browse/DERBY-6297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13720529#comment-13720529
 ] 

Knut Anders Hatlen commented on DERBY-6297:
-------------------------------------------

(See also discussion about this failure in DERBY-6216.)

A workaround may be to add a WHERE clause to the SELECT statements so that they 
only look for the statements that are explicitly run by the test. Still, we 
should try to find out why the getSchema() meta-data queries sometimes turn up 
in the results and sometimes don't, before we close this issue.
                
> Intermittent failures in XplainStatisticsTest.testSimpleXplainOnly
> ------------------------------------------------------------------
>
>                 Key: DERBY-6297
>                 URL: https://issues.apache.org/jira/browse/DERBY-6297
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.11.0.0
>            Reporter: Knut Anders Hatlen
>
> XplainStatisticsTest.testSimpleXplainOnly fails intermittently.
> Examples:
> http://download.java.net/javadesktop/derby/javadb-5579342-report/javadb-task-3689858.html
>     junit.framework.AssertionFailedError: Column value mismatch @ column '1', 
> row 1:
>     Expected: >1<
>     Found:    >2<
>       at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1278)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1190)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1077)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1000)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:957)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:915)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertSingleValueResultSet(JDBC.java:900)
>       at 
> org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest.testSimpleXplainOnly(XplainStatisticsTest.java:1148)
>       at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
>       at 
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
>       at 
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
>       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)
>       at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> http://download.java.net/javadesktop/derby/javadb-5579365-report/javadb-task-3690182.html
>     junit.framework.AssertionFailedError: Column value mismatch @ column '1', 
> row 1:
>     Expected: >4<
>     Found:    >7<
>       at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1278)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1190)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1077)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1000)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:957)
>       at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:915)
>       at 
> org.apache.derbyTesting.junit.JDBC.assertSingleValueResultSet(JDBC.java:900)
>       at 
> org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest.testSimpleXplainOnly(XplainStatisticsTest.java:1183)
>       at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
>       at 
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
>       at 
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
>       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)
>       at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to