[
https://issues.apache.org/jira/browse/DERBY-6495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Myrna van Lunteren updated DERBY-6495:
--------------------------------------
Attachment: DERBY-6495.diff
This patch addresses a number of selects in the decorateSQL, and 2 instances
(the one from the failure reported, and one more) in testBasic.
All other selects where multiple rows might qualify have multiple columns in
the order by.
I'll commit this shortly and will assume this addresses the issue.
> Error in SelectivityTest.testBasic
> ----------------------------------
>
> Key: DERBY-6495
> URL: https://issues.apache.org/jira/browse/DERBY-6495
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.11.0.0
> Reporter: Rick Hillegas
> Assignee: Myrna van Lunteren
> Attachments: DERBY-6495.diff
>
>
> The nightly test results at
> http://download.java.net/javadesktop/derby/request_5588377/javadb-task-3815121.html
> show this error:
> junit.framework.AssertionFailedError: Column value mismatch @ column
> 'STATS', row 1:
> Expected: >numunique= 3 numrows= 7<
> Found: >numunique= 7 numrows= 7<
> at
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1291)
> at
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1203)
> at
> org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.java:1090)
> at
> org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:1013)
> at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:970)
> at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:928)
> at
> org.apache.derbyTesting.functionTests.tests.lang.SelectivityTest.testBasic(SelectivityTest.java:1181)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:118)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:440)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:457)
> 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)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
