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 Kathey Marsden <km...@sbcglobal.net> on 2009/04/07 00:55:15 UTC
Extra row in SYS.SYSROUTINEPERMS with hard upgrade testing 10.3 ->
10.5
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
Re: Extra row in SYS.SYSROUTINEPERMS with hard upgrade testing 10.1
-> 10.5
Posted by Kathey Marsden <km...@sbcglobal.net>.
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
>
>
>
>