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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2009/12/18 16:21:23 UTC

[jira] Created: (DERBY-4485) Add dblook support for UDTs.

Add dblook support for UDTs.
----------------------------

                 Key: DERBY-4485
                 URL: https://issues.apache.org/jira/browse/DERBY-4485
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.6.0.0
            Reporter: Rick Hillegas


The dblook tool should support UDTs and the USAGE privileges granted on them.

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


[jira] Closed: (DERBY-4485) Add dblook support for UDTs.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas closed DERBY-4485.
--------------------------------

    Resolution: Fixed

> Add dblook support for UDTs.
> ----------------------------
>
>                 Key: DERBY-4485
>                 URL: https://issues.apache.org/jira/browse/DERBY-4485
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.6.0.0
>            Reporter: Rick Hillegas
>         Attachments: derby-4485-01-aa-basicDblook.diff
>
>
> The dblook tool should support UDTs and the USAGE privileges granted on them.

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


[jira] Updated: (DERBY-4485) Add dblook support for UDTs.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-4485:
---------------------------------

    Attachment: derby-4485-01-aa-basicDblook.diff

Attaching derby-4485-01-aa-basicDblook.diff. This patch improves dblook to emit DDL for recreating UDTs and the USAGE privileges on them. Regression tests passed cleanly for me. Committed  at revision 892627.


Touches the following files:

M      java/tools/org/apache/derby/tools/dblook.java

Changed the name of a method.


M      java/tools/org/apache/derby/impl/tools/dblook/DB_Alias.java

Reworked to emit DDL for recreating UDTs.


M      java/tools/org/apache/derby/impl/tools/dblook/DB_GrantRevoke.java

Added logic for recreating the USAGE privileges on UDTs.


M      java/tools/org/apache/derby/loc/toolsmessages.properties

New header messages emitted by dblook.



M      java/engine/org/apache/derby/catalog/AliasInfo.java

Improved the javadoc header while I was in there.


M      java/engine/org/apache/derby/catalog/types/UDTAliasInfo.java

Changed the toString() method of the UDT alias info. This is what dblook  uses to reconstruct object-specific clauses for alias-recreating DDL.


M      java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_makeDB_2.sql
M      java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out
M      java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out

Added a test case for recreating UDTs.


> Add dblook support for UDTs.
> ----------------------------
>
>                 Key: DERBY-4485
>                 URL: https://issues.apache.org/jira/browse/DERBY-4485
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.6.0.0
>            Reporter: Rick Hillegas
>         Attachments: derby-4485-01-aa-basicDblook.diff
>
>
> The dblook tool should support UDTs and the USAGE privileges granted on them.

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