1
DROP TABLE IF EXISTS t1;
4
, padding VARCHAR(200) NOT NULL
7
INSERT INTO t1 VALUES (1, "I love testing.");
8
INSERT INTO t1 VALUES (2, "I hate testing.");
9
UPDATE t1 SET padding= "XXX" WHERE id= 1;
10
UPDATE t1 SET padding= "AAA";
13
id int AUTO_INCREMENT NOT NULL PRIMARY KEY
17
INSERT INTO t1 (name,alias) VALUES ("jeff lebowski","dude");
18
UPDATE t1 SET alias = "the dude" WHERE alias = "dude";
22
, counter INT NOT NULL
25
INSERT INTO t1 (id, counter) VALUES (1,1),(2,2),(3,3);
26
UPDATE t1 SET counter = counter + 1 WHERE id = 1;
27
UPDATE t1 SET counter = counter + 1 WHERE id IN (2,3);
31
, padding VARCHAR(200) NOT NULL
34
INSERT INTO t1 VALUES (1, "I love testing.");
35
INSERT INTO t1 VALUES (2, "I hate testing.");
36
UPDATE t1 SET id = 4 WHERE id = 2;
39
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
42
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
45
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
48
UPDATE `test`.`t1` SET `padding`='XXX' WHERE `id`=1;
51
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=1;
52
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=2;
55
DROP TABLE `test`.`t1`;
58
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, `alias` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
61
INSERT INTO `test`.`t1` (`id`,`name`,`alias`) VALUES (1,'jeff lebowski','dude');
64
UPDATE `test`.`t1` SET `alias`='the dude' WHERE `id`=1;
67
DROP TABLE `test`.`t1`;
70
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `counter` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
73
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (1,1);
74
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (2,2);
75
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (3,3);
78
UPDATE `test`.`t1` SET `counter`=2 WHERE `id`=1;
81
UPDATE `test`.`t1` SET `counter`=3 WHERE `id`=2;
82
UPDATE `test`.`t1` SET `counter`=4 WHERE `id`=3;
85
DROP TABLE `test`.`t1`;
88
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
91
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
94
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
97
UPDATE `test`.`t1` SET `id`=4 WHERE `id`=2;
100
DROP TABLE `test`.`t1`;
103
Generating statements for innodb replication log
105
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
108
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
111
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
114
UPDATE `test`.`t1` SET `padding`='XXX' WHERE `id`=1;
117
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=1;
118
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `id`=2;
121
DROP TABLE `test`.`t1`;
124
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, `alias` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
127
INSERT INTO `test`.`t1` (`id`,`name`,`alias`) VALUES (1,'jeff lebowski','dude');
130
UPDATE `test`.`t1` SET `alias`='the dude' WHERE `id`=1;
133
DROP TABLE `test`.`t1`;
136
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `counter` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
139
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (1,1);
140
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (2,2);
141
INSERT INTO `test`.`t1` (`id`,`counter`) VALUES (3,3);
144
UPDATE `test`.`t1` SET `counter`=2 WHERE `id`=1;
147
UPDATE `test`.`t1` SET `counter`=3 WHERE `id`=2;
148
UPDATE `test`.`t1` SET `counter`=4 WHERE `id`=3;
151
DROP TABLE `test`.`t1`;
154
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
157
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
160
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
163
UPDATE `test`.`t1` SET `id`=4 WHERE `id`=2;
166
DROP TABLE `test`.`t1`;
168
SET GLOBAL transaction_log_truncate_debug= true;