You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2016/03/19 17:38:33 UTC
[jira] [Assigned] (TRAFODION-1901) allow more flexible
column-definition in create table ddl
[ https://issues.apache.org/jira/browse/TRAFODION-1901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma reassigned TRAFODION-1901:
---------------------------------------
Assignee: Anoop Sharma
> allow more flexible column-definition in create table ddl
> ---------------------------------------------------------
>
> Key: TRAFODION-1901
> URL: https://issues.apache.org/jira/browse/TRAFODION-1901
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: liu ming
> Assignee: Anoop Sharma
>
> Current Trafodion DDL syntax for CREATE TABLE is very strict to ANSI standard about column-definition.
> column-definition is:
> column data-type
> [DEFAULT default | NO DEFAULT]
> [[CONSTRAINT constraint-name] column-constraint]
> So constraint like 'NOT NULL' must follow the DEFAULT descriptor. In many other databases, this is allowed. So if Trafodion make this more flexible, it will help database migration.
> Here is a test case:
> CREATE TABLE TABLETEST1
> (MARK_ID SMALLINT NOT NULL,
> BEGIN_TIME DATE NOT NULL DEFAULT date'2008-01-01',
> END_TIME DATE NOT NULL DEFAULT date'2018-01-01',
> ACTIVE_FLAG SMALLINT,
> MARK_NAME VARCHAR(20),
> DESC_TXT VARCHAR(80),
> primary key(MARK_ID, BEGIN_TIME, END_TIME)
> );
> *** ERROR[15001] A syntax error occurred at or before:
> CREATE TABLE TABLETEST (MARK_ID SMALLINT NO
> T NULL, BEGIN_TIME DATE NOT NULL DEFAULT date'2008-01-01', END
> ^ (134 characters from start of SQL statement)
> *** ERROR[8822] The statement was not prepared.
> Trafodion support of above DDL will greatly simplify the database migration from other databases into Trafodion.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)