1
DROP TABLE IF EXISTS t1;
5
, padding VARCHAR(200) NOT NULL
8
INSERT INTO t1 VALUES (1, 1, "I love testing.");
9
INSERT INTO t1 VALUES (2, 2, "I hate testing.");
10
INSERT INTO t1 VALUES (2, 3, "I hate and love testing.");
11
INSERT INTO t1 VALUES (3, 3, "I adore testing.");
12
UPDATE t1 SET padding= "XXX" WHERE k1= 1 AND k2= 1;
13
UPDATE t1 SET padding= "YYY" WHERE k1= 2;
14
UPDATE t1 SET padding= "ZZZ" WHERE k2= 3;
15
UPDATE t1 SET padding= "AAA";
18
DROP TABLE IF EXISTS `test`.`t1`;
21
CREATE TABLE `t1` ( `k1` INT NOT NULL, `k2` INT NOT NULL, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`k1`,`k2`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
24
INSERT INTO `test`.`t1` (`k1`,`k2`,`padding`) VALUES (1,1,'I love testing.');
27
INSERT INTO `test`.`t1` (`k1`,`k2`,`padding`) VALUES (2,2,'I hate testing.');
30
INSERT INTO `test`.`t1` (`k1`,`k2`,`padding`) VALUES (2,3,'I hate and love testing.');
33
INSERT INTO `test`.`t1` (`k1`,`k2`,`padding`) VALUES (3,3,'I adore testing.');
36
UPDATE `test`.`t1` SET `padding`='XXX' WHERE `k1`=1 AND `k2`=1;
39
UPDATE `test`.`t1` SET `padding`='YYY' WHERE `k1`=2 AND `k2`=2;
40
UPDATE `test`.`t1` SET `padding`='YYY' WHERE `k1`=2 AND `k2`=3;
43
UPDATE `test`.`t1` SET `padding`='ZZZ' WHERE `k1`=2 AND `k2`=3;
44
UPDATE `test`.`t1` SET `padding`='ZZZ' WHERE `k1`=3 AND `k2`=3;
47
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `k1`=1 AND `k2`=1;
48
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `k1`=2 AND `k2`=2;
49
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `k1`=2 AND `k2`=3;
50
UPDATE `test`.`t1` SET `padding`='AAA' WHERE `k1`=3 AND `k2`=3;
53
DROP TABLE `test`.`t1`;
55
SET GLOBAL transaction_log_truncate_debug= true;