2
# Tests inserting/deleting/updating null values
6
DROP TABLE IF EXISTS t1, t2, t3, t4;
9
CREATE TABLE t1 (a INT NOT NULL, b CHAR(1000), PRIMARY KEY (a));
11
INSERT INTO t1 VALUES (1,"update me");
12
INSERT INTO t1 VALUES (2,'');
13
INSERT INTO t1 VALUES (3,NULL);
15
UPDATE t1 SET b= "updated" WHERE a= 2;
16
UPDATE t1 SET a= 4 WHERE b IS NULL;
17
UPDATE t1 SET b= NULL WHERE a= 1;
19
DELETE FROM t1 where b is NULL;
21
CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT, b INT, PRIMARY KEY(a));
22
INSERT INTO t2 (b) VALUES(NULL);
23
INSERT INTO t2 (b) VALUES(0);
25
CREATE TABLE t3 (a INT NOT NULL, b ENUM ('1','2'), PRIMARY KEY(a));
26
INSERT INTO t3 VALUES (1,'1');
27
INSERT INTO t3 VALUES (2,NULL);
29
CREATE TABLE t4 (id INT NOT NULL, col0_int INT DEFAULT NULL, col1_int INT DEFAULT NULL, PRIMARY KEY (id));
30
INSERT INTO t4 VALUES (1, NULL, 1);
31
UPDATE t4 SET col0_int= 0 WHERE col1_int != 2;
32
UPDATE t4 SET col0_int= NULL WHERE col1_int != 2;
34
DROP TABLE t1, t2, t3, t4;