[jira] [Updated] (DERBY-6495) Error in SelectivityTest.testBasic

["Myrna van Lunteren (JIRA)" <ji...@apache.org>]

     [ 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)