1
DROP TABLE IF EXISTS t1, t2, t3, t4;
2
CREATE TABLE t1 (a INT NOT NULL, b CHAR(1000), PRIMARY KEY (a));
3
INSERT INTO t1 VALUES (1,"update me");
4
INSERT INTO t1 VALUES (2,'');
5
INSERT INTO t1 VALUES (3,NULL);
6
UPDATE t1 SET b= "updated" WHERE a= 2;
7
UPDATE t1 SET a= 4 WHERE b IS NULL;
8
UPDATE t1 SET b= NULL WHERE a= 1;
9
DELETE FROM t1 where b is NULL;
10
CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT, b INT, PRIMARY KEY(a));
11
INSERT INTO t2 (b) VALUES(NULL);
12
INSERT INTO t2 (b) VALUES(0);
13
CREATE TABLE t3 (a INT NOT NULL, b ENUM ('1','2'), PRIMARY KEY(a));
14
INSERT INTO t3 VALUES (1,'1');
15
INSERT INTO t3 VALUES (2,NULL);
16
CREATE TABLE t4 (id INT NOT NULL, col0_int INT DEFAULT NULL, col1_int INT DEFAULT NULL, PRIMARY KEY (id));
17
INSERT INTO t4 VALUES (1, NULL, 1);
18
UPDATE t4 SET col0_int= 0 WHERE col1_int != 2;
19
UPDATE t4 SET col0_int= NULL WHERE col1_int != 2;
20
DROP TABLE t1, t2, t3, t4;
22
CREATE TABLE `test`.`t1` ( `a` INT NOT NULL, `b` VARCHAR(1000) COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`a`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
25
INSERT INTO `test`.`t1` (`a`,`b`) VALUES (1,'update me');
28
INSERT INTO `test`.`t1` (`a`,`b`) VALUES (2,'');
31
INSERT INTO `test`.`t1` (`a`,`b`) VALUES (3,NULL);
34
UPDATE `test`.`t1` SET `b`='updated' WHERE `a`=2;
37
UPDATE `test`.`t1` SET `a`=4 WHERE `a`=3;
40
UPDATE `test`.`t1` SET `b`=NULL WHERE `a`=1;
43
DELETE FROM `test`.`t1` WHERE `a`=1;
44
DELETE FROM `test`.`t1` WHERE `a`=4;
47
CREATE TABLE `test`.`t2` ( `a` INT NOT NULL AUTO_INCREMENT, `b` INT DEFAULT NULL, PRIMARY KEY (`a`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
50
INSERT INTO `test`.`t2` (`a`,`b`) VALUES (1,NULL);
53
INSERT INTO `test`.`t2` (`a`,`b`) VALUES (2,0);
56
CREATE TABLE `test`.`t3` ( `a` INT NOT NULL, `b` ENUM('1','2') DEFAULT NULL, PRIMARY KEY (`a`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
59
INSERT INTO `test`.`t3` (`a`,`b`) VALUES (1,'1');
62
INSERT INTO `test`.`t3` (`a`,`b`) VALUES (2,NULL);
65
CREATE TABLE `test`.`t4` ( `id` INT NOT NULL, `col0_int` INT DEFAULT NULL, `col1_int` INT DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
68
INSERT INTO `test`.`t4` (`id`,`col0_int`,`col1_int`) VALUES (1,NULL,1);
71
UPDATE `test`.`t4` SET `col0_int`=0 WHERE `id`=1;
74
UPDATE `test`.`t4` SET `col0_int`=NULL WHERE `id`=1;
77
DROP TABLE `test`.`t1`;
80
DROP TABLE `test`.`t2`;
83
DROP TABLE `test`.`t3`;
86
DROP TABLE `test`.`t4`;
89
Generating statements for innodb replication log
91
CREATE TABLE `test`.`t1` ( `a` INT NOT NULL, `b` VARCHAR(1000) COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`a`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
94
INSERT INTO `test`.`t1` (`a`,`b`) VALUES (1,'update me');
97
INSERT INTO `test`.`t1` (`a`,`b`) VALUES (2,'');
100
INSERT INTO `test`.`t1` (`a`,`b`) VALUES (3,NULL);
103
UPDATE `test`.`t1` SET `b`='updated' WHERE `a`=2;
106
UPDATE `test`.`t1` SET `a`=4 WHERE `a`=3;
109
UPDATE `test`.`t1` SET `b`=NULL WHERE `a`=1;
112
DELETE FROM `test`.`t1` WHERE `a`=1;
113
DELETE FROM `test`.`t1` WHERE `a`=4;
116
CREATE TABLE `test`.`t2` ( `a` INT NOT NULL AUTO_INCREMENT, `b` INT DEFAULT NULL, PRIMARY KEY (`a`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
119
INSERT INTO `test`.`t2` (`a`,`b`) VALUES (1,NULL);
122
INSERT INTO `test`.`t2` (`a`,`b`) VALUES (2,0);
125
CREATE TABLE `test`.`t3` ( `a` INT NOT NULL, `b` ENUM('1','2') DEFAULT NULL, PRIMARY KEY (`a`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
128
INSERT INTO `test`.`t3` (`a`,`b`) VALUES (1,'1');
131
INSERT INTO `test`.`t3` (`a`,`b`) VALUES (2,NULL);
134
CREATE TABLE `test`.`t4` ( `id` INT NOT NULL, `col0_int` INT DEFAULT NULL, `col1_int` INT DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
137
INSERT INTO `test`.`t4` (`id`,`col0_int`,`col1_int`) VALUES (1,NULL,1);
140
UPDATE `test`.`t4` SET `col0_int`=0 WHERE `id`=1;
143
UPDATE `test`.`t4` SET `col0_int`=NULL WHERE `id`=1;
146
DROP TABLE `test`.`t1`;
149
DROP TABLE `test`.`t2`;
152
DROP TABLE `test`.`t3`;
155
DROP TABLE `test`.`t4`;
157
SET GLOBAL transaction_log_truncate_debug= true;