db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Extra row in SYS.SYSROUTINEPERMS with hard upgrade testing 10.3 -> 10.5
Date Mon, 06 Apr 2009 22:55:15 GMT
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