[
https://issues.apache.org/jira/browse/DERBY-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13780393#comment-13780393
]
Mamta A. Satoor commented on DERBY-6340:
----------------------------------------
Dyre, thanks for working on this feature. I looked through the SQL spec and the
proposed syntax in functional spec indeed adhers to the SQL Spec. Thanks for
including the section numbers, it made it much easier to find the relevant
info. As for the upgrade, I agree that this functionality should be available
only after hard upgrade because system table will have additional information
which will not be recognized by the prior releases. Also, like Rick mentioned,
can you share more information on the casting part of the syntax. Additionally,
some complete examples with how to declare a type and how it will be used will
be nice.
> Add support for CREATE TYPE AS <existing type> (synonym types)
> --------------------------------------------------------------
>
> Key: DERBY-6340
> URL: https://issues.apache.org/jira/browse/DERBY-6340
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Dyre Tjeldvoll
> Assignee: Dyre Tjeldvoll
> Attachments: CreateTypeAs_fs_draft.html
>
>
> The SQL standard (2003) chapter 11.41 <user-defined type definition> allows
> the creation of synonyms or aliases for an existing type: CREATE TYPE AS
> <predefined type>. By allowing this in Derby we would simplify migration
> from, and interoperation with, other databases.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
