1 2 3 4 5 6 7 8 9 10 11 12 |
--source include/have_linux.inc --source include/have_valgrind.inc SET SESSION storage_engine=pbxt; 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; |