trafodion-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Qifan Chen <qifan.c...@esgyn.com>
Subject Re: 答复: add a comment to a table
Date Fri, 01 Apr 2016 10:31:23 GMT
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) <ming.liu@esgyn.cn> wrote:

> Shall we file a JIRA to track this requirement?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Suresh Subbiah [mailto:suresh.subbiah60@gmail.com]
> *发送时间:* 2016年4月1日 11:54
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* 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
> <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, yongqiang.zhan@microinsight.com.cn <
> yongqiang.zhan@microinsight.com.cn> 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?
>
>
>
>
>
>
>
>
> ------------------------------
>
> yongqiang.zhan@microinsight.com.cn
>
>
>



-- 
Regards, --Qifan

Mime
View raw message