Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Thu, 25 Jul 2013 15:35:50 +0000 (UTC)
From: "ASF subversion and git services (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12658736.1374233842679.112153.1374766550300@arcas>
In-Reply-To: <JIRA.12658736.1374233842679@arcas>
References: <JIRA.12658736.1374233842679@arcas>
Subject: [jira] [Commented] (DERBY-6298) Documentation implies column NOT
 NULL constraint cannot be named, but it can be.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-6298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13719701#comment-13719701 ] 

ASF subversion and git services commented on DERBY-6298:
--------------------------------------------------------

Commit 1507015 from [~chaase3] in branch 'docs/branches/10'
[ https://svn.apache.org/r1507015 ]

DERBY-6298  Documentation implies column NOT NULL constraint cannot be named, but it can be.  

Merged patch DERBY-6298-2.diff to 10.8 doc branch from trunk revision 1506977.
                
> 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
>         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