[ https://issues.apache.org/jira/browse/TRAFODION-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16513962#comment-16513962 ]
ASF GitHub Bot commented on TRAFODION-1782: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/trafodion/pull/1608 > Error 1135 for a primary key column not declared NOT NULL > --------------------------------------------------------- > > Key: TRAFODION-1782 > URL: https://issues.apache.org/jira/browse/TRAFODION-1782 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 0.6 (pre-incubation) > Reporter: Hans Zeller > Assignee: Anoop Sharma > Priority: Minor > > When creating a table like this: > create table t(a int primary key) > or > create table t(a int, primary key(a)) > Trafodion issues an error 1135 (Clustering key column ID must be assigned a > NOT NULL NOT DROPPABLE constraint.). It would be better (and ANSI SQL > compliant) if that constraint would be added implicitly, without generating > an error. -- This message was sent by Atlassian JIRA (v7.6.3#76005)