[ 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)