[
https://issues.apache.org/jira/browse/TRAFODION-1915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming updated TRAFODION-1915:
--------------------------------
Priority: Minor (was: Major)
> support adding/retrieving comments to SQL objects
> -------------------------------------------------
>
> Key: TRAFODION-1915
> URL: https://issues.apache.org/jira/browse/TRAFODION-1915
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: liu ming
> Priority: Minor
>
> It is desired to have compatible capability of Oracle's syntax to add/get
> comments to SQL objects, like tables and columns, etc.
> QiFan give a very good initial design for this:
> 1. add a new type for column TEXT_TYPE in meta-table
> TRAFODION."_MD_".TEXT, say COMMENT_TYPE;
> 2. allow COMMENT ON syntax in the parser;
> 3. convert the content of COMMENT ON stmt into insertion/update of a
> row(s) in the TEXT meta-data table for the SQL object in question;
> 4. write a UDF to show the comment easily for a SQL object, by hiding the
> join of the meta-data TEXT and OBJECTS table.
> Can be done increamentally since there are a lot of SQL objects. And multiple
> changes to different components.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
