← Back to branch summary

~drizzle-trunk/drizzle/development

1039.5.42 by Jay Pipes
Splits out the previously aggregated all.test case into separate test 
1
 
DROP TABLE IF EXISTS t1;

2
 
CREATE TABLE t1 (

3
 
id INT NOT NULL

4
 
, padding VARCHAR(200) NOT NULL

5
 
, PRIMARY KEY (id)

6
 
);

7
 
INSERT INTO t1 VALUES (1, "I love testing.");

8
 
INSERT INTO t1 VALUES (2, "I hate testing.");

9
 
DELETE FROM t1 where id = 1;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
10
 
DROP TABLE t1;

11
 
CREATE TABLE t1 (

12
 
id INT NOT NULL

13
 
, other INT NOT NULL

14
 
, PRIMARY KEY (id)

15
 
);

16
 
INSERT INTO t1 VALUES (1, 1);

17
 
INSERT INTO t1 VALUES (2, 2);

18
 
INSERT INTO t1 VALUES (3, 3);

19
 
INSERT INTO t1 VALUES (4, 4);

20
 
INSERT INTO t1 VALUES (5, 5);

21
 
INSERT INTO t1 VALUES (6, 6);

22
 
INSERT INTO t1 VALUES (7, 7);

23
 
INSERT INTO t1 VALUES (8, 8);

24
 
DELETE FROM t1;

25
 
DROP TABLE t1;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
26
 
Start Test of LP Bug #496101

27
 
CREATE TABLE t1 (

28
 
id INT NOT NULL

29
 
, padding VARCHAR(200) NOT NULL

30
 
, PRIMARY KEY (id)

31
 
);

32
 
START TRANSACTION;

33
 
INSERT INTO t1 VALUES (1, "I love testing.");

34
 
INSERT INTO t1 VALUES (2, "I hate testing.");

35
 
DELETE FROM t1 where id = 1;

36
 
COMMIT;

37
 
DROP TABLE t1;

38
 
End Test of LP Bug #496101
2092.1.1 by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. 
39
 
SET AUTOCOMMIT=0;
2363.1.5 by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. 
40
 
CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
41
 
COMMIT;

42
 
START TRANSACTION;
1143.2.10 by Jay Pipes
Phase 2 new replication work: 
43
 
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
44
 
COMMIT;

45
 
START TRANSACTION;
1143.2.10 by Jay Pipes
Phase 2 new replication work: 
46
 
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
47
 
COMMIT;

48
 
START TRANSACTION;
1143.2.10 by Jay Pipes
Phase 2 new replication work: 
49
 
DELETE FROM `test`.`t1` WHERE `id`=1;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
50
 
COMMIT;
2092.1.1 by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. 
51
 
SET AUTOCOMMIT=0;
1308.2.4 by Jay Pipes
Adds DROP TABLE to the list of non RAW_SQL statements in replication stream 
52
 
DROP TABLE `test`.`t1`;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
53
 
COMMIT;
2092.1.1 by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. 
54
 
SET AUTOCOMMIT=0;
2363.1.5 by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. 
55
 
CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `other` INT NOT NULL,   PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
56
 
COMMIT;

57
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
58
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (1,1);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
59
 
COMMIT;

60
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
61
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (2,2);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
62
 
COMMIT;

63
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
64
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (3,3);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
65
 
COMMIT;

66
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
67
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (4,4);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
68
 
COMMIT;

69
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
70
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (5,5);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
71
 
COMMIT;

72
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
73
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (6,6);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
74
 
COMMIT;

75
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
76
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (7,7);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
77
 
COMMIT;

78
 
START TRANSACTION;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
79
 
INSERT INTO `test`.`t1` (`id`,`other`) VALUES (8,8);
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
80
 
COMMIT;
1143.4.6 by Jay Pipes
Adds test case to transaction log for TRUNCATE TABLE. 
81
 
START TRANSACTION;

82
 
DELETE FROM `test`.`t1` WHERE `id`=1;

83
 
DELETE FROM `test`.`t1` WHERE `id`=2;

84
 
DELETE FROM `test`.`t1` WHERE `id`=3;

85
 
DELETE FROM `test`.`t1` WHERE `id`=4;

86
 
DELETE FROM `test`.`t1` WHERE `id`=5;

87
 
DELETE FROM `test`.`t1` WHERE `id`=6;

88
 
DELETE FROM `test`.`t1` WHERE `id`=7;

89
 
DELETE FROM `test`.`t1` WHERE `id`=8;

90
 
COMMIT;
2092.1.1 by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. 
91
 
SET AUTOCOMMIT=0;
1308.2.4 by Jay Pipes
Adds DROP TABLE to the list of non RAW_SQL statements in replication stream 
92
 
DROP TABLE `test`.`t1`;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
93
 
COMMIT;
2092.1.1 by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. 
94
 
SET AUTOCOMMIT=0;
2363.1.5 by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. 
95
 
CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
96
 
COMMIT;

97
 
START TRANSACTION;

98
 
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');

99
 
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');

100
 
DELETE FROM `test`.`t1` WHERE `id`=1;

101
 
COMMIT;
2092.1.1 by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. 
102
 
SET AUTOCOMMIT=0;
1308.2.4 by Jay Pipes
Adds DROP TABLE to the list of non RAW_SQL statements in replication stream 
103
 
DROP TABLE `test`.`t1`;
1143.4.25 by Jay Pipes
Correctly puts START TRANSACTION; COMMIT; containers around group-related SQL statements in the transaction_reader and ensures that when a different type of Statement message is started in an existing Transaction message, that the active Statement message is finalized. 
104
 
COMMIT;
1802.17.17 by Joseph Daly
port additional tests 
105
 









106



Generating statements for innodb replication log








2092.1.1
by David Shrewsbury


Use AUTOCOMMIT=0 with DDL output from transaction_reader.



107



SET AUTOCOMMIT=0;








2363.1.5
by Brian Aker


This patch fixes 798940, we will also just now add the type of index to our create statements.



108



CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;








1802.17.17
by Joseph Daly


port additional tests



109



COMMIT;










110



START TRANSACTION;










111



INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');










112



COMMIT;










113



START TRANSACTION;










114



INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');










115



COMMIT;










116



START TRANSACTION;










117



DELETE FROM `test`.`t1` WHERE `id`=1;










118



COMMIT;








2092.1.1
by David Shrewsbury


Use AUTOCOMMIT=0 with DDL output from transaction_reader.



119



SET AUTOCOMMIT=0;








1802.17.17
by Joseph Daly


port additional tests



120



DROP TABLE `test`.`t1`;










121



COMMIT;








2092.1.1
by David Shrewsbury


Use AUTOCOMMIT=0 with DDL output from transaction_reader.



122



SET AUTOCOMMIT=0;








2363.1.5
by Brian Aker


This patch fixes 798940, we will also just now add the type of index to our create statements.



123



CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `other` INT NOT NULL,   PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;








1802.17.17
by Joseph Daly


port additional tests



124



COMMIT;










125



START TRANSACTION;










126



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (1,1);










127



COMMIT;










128



START TRANSACTION;










129



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (2,2);










130



COMMIT;










131



START TRANSACTION;










132



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (3,3);










133



COMMIT;










134



START TRANSACTION;










135



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (4,4);










136



COMMIT;










137



START TRANSACTION;










138



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (5,5);










139



COMMIT;










140



START TRANSACTION;










141



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (6,6);










142



COMMIT;










143



START TRANSACTION;










144



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (7,7);










145



COMMIT;










146



START TRANSACTION;










147



INSERT INTO `test`.`t1` (`id`,`other`) VALUES (8,8);










148



COMMIT;










149



START TRANSACTION;










150



DELETE FROM `test`.`t1` WHERE `id`=1;










151



DELETE FROM `test`.`t1` WHERE `id`=2;










152



DELETE FROM `test`.`t1` WHERE `id`=3;










153



DELETE FROM `test`.`t1` WHERE `id`=4;










154



DELETE FROM `test`.`t1` WHERE `id`=5;










155



DELETE FROM `test`.`t1` WHERE `id`=6;










156



DELETE FROM `test`.`t1` WHERE `id`=7;










157



DELETE FROM `test`.`t1` WHERE `id`=8;










158



COMMIT;








2092.1.1
by David Shrewsbury


Use AUTOCOMMIT=0 with DDL output from transaction_reader.



159



SET AUTOCOMMIT=0;








1802.17.17
by Joseph Daly


port additional tests



160



DROP TABLE `test`.`t1`;










161



COMMIT;








2092.1.1
by David Shrewsbury


Use AUTOCOMMIT=0 with DDL output from transaction_reader.



162



SET AUTOCOMMIT=0;








2363.1.5
by Brian Aker


This patch fixes 798940, we will also just now add the type of index to our create statements.



163



CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;








1802.17.17
by Joseph Daly


port additional tests



164



COMMIT;










165



START TRANSACTION;










166



INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');










167



INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');










168



DELETE FROM `test`.`t1` WHERE `id`=1;










169



COMMIT;








2092.1.1
by David Shrewsbury


Use AUTOCOMMIT=0 with DDL output from transaction_reader.



170



SET AUTOCOMMIT=0;








1802.17.17
by Joseph Daly


port additional tests



171



DROP TABLE `test`.`t1`;










172



COMMIT;








1143.2.10
by Jay Pipes


Phase 2 new replication work:



173



SET GLOBAL transaction_log_truncate_debug= true;