[
https://issues.apache.org/jira/browse/TRAFODION-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16511795#comment-16511795
]
ASF GitHub Bot commented on TRAFODION-1782:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/trafodion/pull/1608
jira TRAFODION-1782 Auto assignment of NOT NULL attr to primary key cols
details in jira.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/trafodion ansharma_nnpk_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1608.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 #1608
----
commit 5724b2e6c1b2a955ee4ab4cd6a582d1d74fd1003
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-04T18:07:45Z
nonnull pkey, commit #1
commit ba15b2e37c20d2fdc11340e826045c9ce0950571
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-11T17:14:40Z
Merge remote branch 'origin/master' into ansharma_nnpk_br
Conflicts:
core/sql/regress/seabase/EXPECTED031
core/sql/sqlcomp/CmpDescribe.cpp
core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
core/sql/sqlcomp/DefaultConstants.h
commit bc77872838d0e42766e0e54b7a5c3d2139bb7a5b
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-11T17:15:00Z
Merge remote branch 'origin/master' into ansharma_nnpk_br
commit a5eb0b26465fce538b2b5c1e054cdc42aa7423ff
Author: Anoop Sharma <anoop.sharma@...>
Date: 2018-06-13T23:22:18Z
jira TRAFODION-1782 Auto assignment of NOT NULL attr to primary key columns.
details in jira.
regress/seabase/TEST032 has new tests for this enhancement.
----
> 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)
