[
https://issues.apache.org/jira/browse/TRAFODION-2335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16355373#comment-16355373
]
liu ming commented on TRAFODION-2335:
-------------------------------------
* 当前日期作为默认值：
create table t1(c varchar(10) default to_char(sysdate,'YYYYMMDD'));
* 使用sequence作为默认值：
## create sequence test_seq;
## create table sequence_test_tab(c number default test_seq.nextval);
> support functions in the column default definition
> --------------------------------------------------
>
> Key: TRAFODION-2335
> URL: https://issues.apache.org/jira/browse/TRAFODION-2335
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: liu ming
> Assignee: liu ming
> Priority: Minor
>
> It is possible to use Function in create table DDL for column default in some
> other RDBMS, it is desired to support that as well.
> Requirement is still not 100% clear, need further study.
> File JIRA to track first.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
