16
16
INSERT INTO t1 VALUES (2, "I hate testing.");
19
DROP TABLE IF EXISTS `t1`;
22
CREATE TABLE t1 ( id INT NOT NULL PRIMARY KEY , padding VARCHAR(200) NOT NULL );
25
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
26
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
32
CREATE TABLE t1 ( id INT NOT NULL PRIMARY KEY , padding VARCHAR(200) NOT NULL );
35
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
38
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
19
DROP TABLE IF EXISTS `test`.`t1`;
22
CREATE TABLE `t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
25
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
26
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
29
DROP TABLE `test`.`t1`;
32
CREATE TABLE `t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
35
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
38
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
41
DROP TABLE `test`.`t1`;
43
43
SET GLOBAL transaction_log_truncate_debug= true;