00001 # 00002 # Tests inserting/deleting/updating null values 00003 # 00004 00005 --disable_warnings 00006 DROP TABLE IF EXISTS t1, t2, t3, t4; 00007 --enable_warnings 00008 00009 CREATE TABLE t1 (a INT NOT NULL, b CHAR(1000), PRIMARY KEY (a)); 00010 00011 INSERT INTO t1 VALUES (1,"update me"); 00012 INSERT INTO t1 VALUES (2,''); 00013 INSERT INTO t1 VALUES (3,NULL); 00014 00015 UPDATE t1 SET b= "updated" WHERE a= 2; 00016 UPDATE t1 SET a= 4 WHERE b IS NULL; 00017 UPDATE t1 SET b= NULL WHERE a= 1; 00018 00019 DELETE FROM t1 where b is NULL; 00020 00021 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT, b INT, PRIMARY KEY(a)); 00022 INSERT INTO t2 (b) VALUES(NULL); 00023 INSERT INTO t2 (b) VALUES(0); 00024 00025 CREATE TABLE t3 (a INT NOT NULL, b ENUM ('1','2'), PRIMARY KEY(a)); 00026 INSERT INTO t3 VALUES (1,'1'); 00027 INSERT INTO t3 VALUES (2,NULL); 00028 00029 CREATE TABLE t4 (id INT NOT NULL, col0_int INT DEFAULT NULL, col1_int INT DEFAULT NULL, PRIMARY KEY (id)); 00030 INSERT INTO t4 VALUES (1, NULL, 1); 00031 UPDATE t4 SET col0_int= 0 WHERE col1_int != 2; 00032 UPDATE t4 SET col0_int= NULL WHERE col1_int != 2; 00033 00034 DROP TABLE t1, t2, t3, t4;