[jira] [Resolved] (DERBY-6298) Documentation implies column NOT NULL constraint cannot be named, but it can be.

["Kim Haase (JIRA)" <ji...@apache.org>]

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

Kim Haase resolved DERBY-6298.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.8.3.0
                      10.10.1.1
                      10.11.0.0
                      10.9.2.2
    Issue & fix info:   (was: Patch Available)

Thanks again, Dag!

Committed patch DERBY-6298-2.diff to documentation trunk at revision 1506977. 
Merged to 10.10 doc branch at revision 1506988.
Merged to 10.9 doc branch at revision 1507006. 
Merged to 10.8 doc branch at revision 1507015. 

This is an important correction, so I've ported it as far back as 10.8. I could go back farther if that makes sense, but the chances of another Derby release for 10.7 and below seem very small. Anyone who would appreciate further backports, however, should let me know.
                
> Documentation implies column NOT NULL constraint cannot be named, but it can be.
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-6298
>                 URL: https://issues.apache.org/jira/browse/DERBY-6298
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.10.1.1
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>             Fix For: 10.9.2.2, 10.11.0.0, 10.10.1.1, 10.8.3.0
>
>         Attachments: DERBY-6298-2.diff, DERBY-6298.diff, rrefsqlj16095.html, rrefsqlj16095.html
>
>
> Cf syntax description in ref/rrefsqlj16095.html:
> Column-level-constraint
> {
>     NOT NULL |
>     [ [CONSTRAINT constraint-Name]
>     {
>         CHECK (searchCondition) |
>         {
>             PRIMARY KEY |
>             UNIQUE |
>             REFERENCES clause
>         } 
>     }
> }
> but actually this works:
> create table t(i int constraint foo not null); The curly braces around primary, unique and references are redundant as well.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira