Very good plan QiFan. Allow me file a JIRA then. Compatibility will be important.
Thanks, Ming 发件人: Qifan Chen [mailto:[email protected]] 发送时间: 2016年4月1日 18:31 收件人: [email protected] 主题: Re: 答复: add a comment to a table The implementation probably will be involving the following: 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. The task may be a little bit involving :-). Thanks --Qifan On Fri, Apr 1, 2016 at 1:30 AM, Liu, Ming (Ming) <[email protected]<mailto:[email protected]>> wrote: Shall we file a JIRA to track this requirement? Thanks, Ming 发件人: Suresh Subbiah [mailto:[email protected]<mailto:[email protected]>] 发送时间: 2016年4月1日 11:54 收件人: [email protected]<mailto:[email protected]> 主题: Re: add a comment to a table Hi, I do not think Trafodion currently supports Oracle's COMMENT ON syntax https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm It will be a relatively simple feature to add but we do not have it today as far as I know. Thank you Suresh On Thu, Mar 31, 2016 at 9:56 PM, [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> wrote: Hi , all, I want to add a comment to a table,like the use of oracle" comment on table tablename is annotate", How to use jdbc way to implement it? ________________________________ [email protected]<mailto:[email protected]> -- Regards, --Qifan
