[jira] [Created] (TRAFODION-1915) support adding/retrieving comments to SQL objects

["liu ming (JIRA)" <ji...@apache.org>]

liu ming created TRAFODION-1915:
-----------------------------------

             Summary: 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


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)