db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Extra row in SYS.SYSROUTINEPERMS with hard upgrade testing 10.1 -> 10.5
Date Mon, 06 Apr 2009 23:24:35 GMT
Sorry, this was a 10.1 to 10.5 upgrade test.

Kathey Marsden wrote:
> Does this look like a problem?  With hard upgrade testing 10.3 -> 10.5 
> I get an extra row in SYS.SYSROUTINEPERMS.
>
> Here's the failure:
> 1) 
> testSemantics(org.apache.derbyTesting.functionTests.tests.lang.RolesTest)junit.framework.AssertionFailedError:

> SYS.SYSROUTINEPERMS row count: expected:<6> but was:<7>
>    at <unknown class>.<unknown method>(Unknown Source)
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.RolesTest.assertSystableRowCount(RolesTest.java:1148)

>
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.RolesTest.assertSysRoutinePermsRowCount(RolesTest.java:1211)

>
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.RolesTest.testSemantics(RolesTest.java:602)

>
>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45) 
>
>    at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

>
>    at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:105)
> 2) 
> testSemantics(org.apache.derbyTesting.functionTests.tests.lang.RolesTest)junit.framework.AssertionFailedError:

> SYS.SYSROUTINEPERMS row count: expected:<6> but was:<7>
>    at <unknown class>.<unknown method>(Unknown Source)
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.RolesTest.assertSystableRowCount(RolesTest.java:1148)

>
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.RolesTest.assertSysRoutinePermsRowCount(RolesTest.java:1211)

>
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.RolesTest.testSemantics(RolesTest.java:602)

>
>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45) 
>
>    at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

>
>    at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:105)
>    at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>    at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>    at junit.extensions.TestSetup.run(TestSetup.java:23)
>    at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>    at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>    at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>    at junit.extensions.TestSetup.run(TestSetup.java:23)
> 3) 
> testDefaultCollation(org.apache.derbyTesting.functionTests.tests.lang.CollationTest)junit.framework.AssertionFailedError:

> Column value mismatch @ column '1', row 1:
>    Expected: >UCS_BASIC<
>    Found:    >null<
>    at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1095)
>    at 
> org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1007)
>    at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:895)
>    at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:833)
>    at 
> org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:791)
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.CollationTest.checkLangBasedQuery(CollationTest.java:1266)

>
>    at 
> org.apache.derbyTesting.functionTests.tests.lang.CollationTest.testDefaultCollation(CollationTest.java:87)

>
>    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>    at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45) 
>
>    at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

>
>    at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:105)
>    at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>    at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>    at junit.extensions.TestSetup.run(TestSetup.java:23)
>    at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>
>
> and the contents of SYS.SYSROUTINEPERMS after the test run.
>
>
> ij> select * from SYS.SYSROUTINEPERMS;
> ROUTINEPERMSID                      |GRANTEE
>                                             |GRANTOR
>                                                      
> |ALIASID                             |&
> --------------------------------------------------------------------------------------------------------

>
> --------------------------------------------------------------------------------------------------------

>
> ---------------------------------------------------------------------------------------------

>
> aaeec04e-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |NULL
>                                                      
> |c2db804d-0120-7d07-6d40-0000001f9838|N
> a352c053-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |APP
>                                                      
> |bbbd0058-0120-7d05-bee4-0000001038c8|N
> 5b678054-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |APP
>                                                      
> |03d30059-0120-7d05-bee4-0000001038c8|N
> 437c8055-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |APP
>                                                      
> |44ee8065-0120-7d05-bee4-0000001038c8|N
> 6b91c056-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |APP
>                                                      
> |832a0051-0120-7d05-bee4-0000001038c8|N
> e3a74057-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |APP
>                                                      
> |c2db804d-0120-7d07-6d40-0000001f9838|N
> bbbd0058-0120-7d07-6d40-0000001f9838|PUBLIC
>                                             |APP
>                                                      
> |1c16805c-0120-7d05-bee4-0000001038c8|N
>
> 7 rows selected
>
>
>
>


Mime
View raw message