[jira] [Commented] (TRAFODION-3072) Make the primary key have the default not null attribute.
[ https://issues.apache.org/jira/browse/TRAFODION-3072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16480658#comment-16480658 ] Anoop Sharma commented on TRAFODION-3072: - This Jira is duplicate of TRAFODION-1782. That one is being worked on. This Jira should be as duplicate. It is also good to look for an existing Jira before filing and starting work on a new Jira otherwise there may be duplication of work. > 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)
[jira] [Commented] (TRAFODION-3072) Make the primary key have the default not null attribute.
[ https://issues.apache.org/jira/browse/TRAFODION-3072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16478734#comment-16478734 ] ASF GitHub Bot commented on TRAFODION-3072: --- Github user andyyangcn closed the pull request at: https://github.com/apache/trafodion/pull/1567 > 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)
[jira] [Commented] (TRAFODION-3072) Make the primary key have the default not null attribute.
[ https://issues.apache.org/jira/browse/TRAFODION-3072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16478521#comment-16478521 ] ASF GitHub Bot commented on TRAFODION-3072: --- GitHub user andyyangcn opened a pull request: https://github.com/apache/trafodion/pull/1567 [TRAFODION-3072] Make the primary key have the default not null attri… …bute. You can merge this pull request into a Git repository by running: $ git pull https://github.com/andyyangcn/incubator-trafodion bugfix Alternatively you can review and apply these changes as the patch at: https://github.com/apache/trafodion/pull/1567.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1567 commit 1a820148bb26f69b9b345d232f80ee22ab72292b Author: kakaxi3019 Date: 2018-05-17T05:07:58Z [TRAFODION-3072] Make the primary key have the default not null attribute. > 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)
[jira] [Commented] (TRAFODION-3072) Make the primary key have the default not null attribute.
[ 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)