[jira] [Work started] (TRAFODION-1782) Error 1135 for a primary key column not declared NOT NULL

["Anoop Sharma (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TRAFODION-1782 started by Anoop Sharma.
-----------------------------------------------
> 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)