~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
create table t1 (a int, b int not null, c int null, d int not null, pk int primary key);
show create table t1;
insert into t1 values (0,0, 0, 0,0);
--error ER_BAD_NULL_ERROR
insert into t1 values (NULL, NULL, NULL, NULL, 1);
insert into t1 values (NULL, 1, NULL, 1, 2);
--error ER_BAD_NULL_ERROR
insert into t1 values (1,2,3,NULL, 3);
drop table t1;