Re: 答复: add a comment to a table

[Qifan Chen]

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)  wrote:

> Shall we file a JIRA to track this requirement?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Suresh Subbiah [mailto:suresh.subbia...@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
> *
>
>
>
> *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.z...@microinsight.com.cn <
> yongqiang.z...@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.z...@microinsight.com.cn
>
>
>



-- 
Regards, --Qifan

答复: add a comment to a table

[Liu, Ming (Ming)]

Shall we file a JIRA to track this requirement?

Thanks,
Ming

发件人: Suresh Subbiah [mailto:suresh.subbia...@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

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.z...@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.z...@microinsight.com.cn