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

Bryan Pendleton commented on DERBY-3767:
----------------------------------------

Try adding the following:

  alter table a alter column a2 not null;  
  alter table a alter column a3 not null;

Immediately before the "alter table add constraint" line.

In order for a column to be a member of a primary key,
the column must be marked as "not null" first.

With that change in place, does the test seem to make more sense?


> Convert "org.apache.derbyTesting.functionTests.tests.lang.nulls.sql" to 
> junit. 
> -------------------------------------------------------------------------------
>
>                 Key: DERBY-3767
>                 URL: https://issues.apache.org/jira/browse/DERBY-3767
>             Project: Derby
>          Issue Type: Test
>          Components: Test
>         Environment: windows xp, sp2.
>            Reporter: Junjie Peng
>            Assignee: Junjie Peng
>         Attachments: derby-3767-1-patch.txt, derby-3767-1-stat.txt
>
>   Original Estimate: 168h
>  Remaining Estimate: 168h
>
> Convert "org.apache.derbyTesting.functionTests.tests.lang.nulls.sql" to 
> junit. It it a part of 2008 GSOC.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to