Drizzled Public API Documentation

null_values.inc
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;