[jira] Updated: (DERBY-3191) SQL roles: add upgrade support

["Dag H. Wanvik (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-3191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-3191:
---------------------------------

    Attachment: DERBY-3191.stat
                DERBY-3191.diff

Attaching  a first rev of a patch for upgrade support and upgrade test
for roles.

Description:
 
M      java/engine/org/apache/derby/impl/sql/catalog/DD_Version.java

This contains the upgrade action which adds SYS.SYSROLES at upgrade time.

M      java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Changes10_4.java

Two new tests to verify that roles can be created and dropped after upgrade. 

M      java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/PhaseChanger.java
M      java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/UpgradeRun.java
M      java/testing/org/apache/derbyTesting/junit/TestConfiguration.java

Changes testing framework to allow an additional database
("ROLES_10_4") in upgrade tests to be used which requires
sqlAuthorization.

Regression tests ran ok, including ugrade tests. I ran using
these releases in my derbyTesting.oldReleasePath:

10.0.2.1
10.1.1.0
10.1.2.1
10.1.3.1
10.2.1.6
10.2.2.0
10.3.1.4


> SQL roles: add upgrade support
> ------------------------------
>
>                 Key: DERBY-3191
>                 URL: https://issues.apache.org/jira/browse/DERBY-3191
>             Project: Derby
>          Issue Type: Improvement
>            Reporter: Dag H. Wanvik
>            Assignee: Dag H. Wanvik
>         Attachments: DERBY-3191.diff, DERBY-3191.stat
>
>
> Derby roles introduce a new system catalog (SYSROLES). When a database
> is hard upgraded, this catalog needs to be added.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.