You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2013/12/24 15:32:55 UTC

[jira] [Commented] (DERBY-6441) Non-deterministic query results in GrantRevokeDDLTest

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

ASF subversion and git services commented on DERBY-6441:
--------------------------------------------------------

Commit 1553280 from [~rhillegas] in branch 'code/trunk'
[ https://svn.apache.org/r1553280 ]

DERBY-6441: Add ORDER BY clauses to a number of queries in GrantRevokeDDLTest in order to force deterministic results; checks in derby-6441-01-addOrderByClauses.diff.

> Non-deterministic query results in GrantRevokeDDLTest
> -----------------------------------------------------
>
>                 Key: DERBY-6441
>                 URL: https://issues.apache.org/jira/browse/DERBY-6441
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>            Reporter: Rick Hillegas
>         Attachments: derby-6441-01-addOrderByClauses.diff
>
>
> The lack of an ORDER BY clause on a query in GrantRevokeDDLTest.getGrantRevokeDDL can give rise to errors like the following (seen in test run http://javadb.se.oracle.com/javadb-testing/request_5586034/javadb-task-3781856.html):
>     junit.framework.AssertionFailedError: Column value mismatch @ column 'SCHEMANAME', row 4:
>     Expected: >SATHEESH<
>     Found:    >TEST_DBO<
> 	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.functionTests.tests.lang.GrantRevokeDDLTest.testGrantRevokeDDL(GrantRevokeDDLTest.java:451)
> 	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 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)
> 	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)
> 	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 junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
>   



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)