[
https://issues.apache.org/jira/browse/DERBY-3767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12613883#action_12613883
]
Junjie Peng commented on DERBY-3767:
------------------------------------
I'm still not so clear.
This is code from Line 72 to Line 82 in nulls.sql,
"
-- try with multiple null columns
create table a (a1 int not null, a2 int, a3 int);
insert into a values(1,1,1);
-- table with no null data should work
alter table a add constraint ap1 primary key(a1, a2, a3);
-- insert a null into one of the primary key columns should fail
insert into a values(1, NULL, 1);
drop table a;
"
It's expected
{
-- table with no null data should work
alter table a add constraint ap1 primary key(a1, a2, a3);
}
but this line fails in my ij.
And it's expected
{
-- insert a null into one of the primary key columns should fail
insert into a values(1, NULL, 1);
}
but this line is OK in my ij.
Besides, if the create sentence is "create table a (a1 int not null, a2 int not
null, a3 int not null)"-----which is consistent with your new comments "-- try
with multiple non-null columns.
", It will run as the comments expected. Is it suitable?
> 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.
