[
https://issues.apache.org/jira/browse/TRAFODION-3072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16478497#comment-16478497
]
Yang, Yongfeng commented on TRAFODION-3072:
-------------------------------------------
Change the create table statement fromĀ
create table t1(id int not null primary key, id2 int);
to
create table t1(id int primary key, id2 int);
> Make the primary key have the default not null attribute.
> ---------------------------------------------------------
>
> Key: TRAFODION-3072
> URL: https://issues.apache.org/jira/browse/TRAFODION-3072
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Yang, Yongfeng
> Assignee: Yang, Yongfeng
> Priority: Major
>
> For a primary key column, it shouldn't be null. But when we define a primary
> key in Trafodion, we still need to mark the column "not null" explicitly.
> That's is redundant.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)