|
1662.3.3
by Joe Daly
add new test for multi table updates within a transaction |
1 |
DROP TABLE IF EXISTS t1, t2; |
2 |
CREATE TABLE t1 ( |
|
3 |
id INT NOT NULL PRIMARY KEY |
|
4 |
);
|
|
5 |
CREATE TABLE t2 ( |
|
6 |
id INT NOT NULL PRIMARY KEY |
|
7 |
);
|
|
8 |
START TRANSACTION; |
|
9 |
INSERT INTO t1 VALUES (1); |
|
10 |
INSERT INTO t2 VALUES (1); |
|
11 |
COMMIT; |
|
12 |
START TRANSACTION; |
|
13 |
UPDATE t1 SET id=2 WHERE id=1; |
|
14 |
UPDATE t2 SET id=2 WHERE id=1; |
|
15 |
COMMIT; |
|
16 |
START TRANSACTION; |
|
17 |
DELETE FROM t1 WHERE id=2; |
|
18 |
DELETE FROM t2 WHERE id=2; |
|
19 |
COMMIT; |
|
20 |
DROP TABLE t1, t2; |
|
21 |
START TRANSACTION; |
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
22 |
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci; |
|
1662.3.3
by Joe Daly
add new test for multi table updates within a transaction |
23 |
COMMIT; |
24 |
START TRANSACTION; |
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
25 |
CREATE TABLE `test`.`t2` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci; |
|
1662.3.3
by Joe Daly
add new test for multi table updates within a transaction |
26 |
COMMIT; |
27 |
START TRANSACTION; |
|
28 |
INSERT INTO `test`.`t1` (`id`) VALUES (1); |
|
29 |
INSERT INTO `test`.`t2` (`id`) VALUES (1); |
|
30 |
COMMIT; |
|
31 |
START TRANSACTION; |
|
32 |
UPDATE `test`.`t1` SET `id`=2 WHERE `id`=1; |
|
33 |
UPDATE `test`.`t2` SET `id`=2 WHERE `id`=1; |
|
34 |
COMMIT; |
|
35 |
START TRANSACTION; |
|
36 |
DELETE FROM `test`.`t1` WHERE `id`=2; |
|
37 |
DELETE FROM `test`.`t2` WHERE `id`=2; |
|
38 |
COMMIT; |
|
39 |
START TRANSACTION; |
|
40 |
DROP TABLE `test`.`t1`; |
|
41 |
COMMIT; |
|
42 |
START TRANSACTION; |
|
43 |
DROP TABLE `test`.`t2`; |
|
44 |
COMMIT; |
|
|
1802.17.17
by Joseph Daly
port additional tests |
45 |
|
46 |
Generating statements for innodb replication log |
|
47 |
START TRANSACTION; |
|
48 |
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci; |
|
49 |
COMMIT; |
|
50 |
START TRANSACTION; |
|
51 |
CREATE TABLE `test`.`t2` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci; |
|
52 |
COMMIT; |
|
53 |
START TRANSACTION; |
|
54 |
INSERT INTO `test`.`t1` (`id`) VALUES (1); |
|
55 |
INSERT INTO `test`.`t2` (`id`) VALUES (1); |
|
56 |
COMMIT; |
|
57 |
START TRANSACTION; |
|
58 |
UPDATE `test`.`t1` SET `id`=2 WHERE `id`=1; |
|
59 |
UPDATE `test`.`t2` SET `id`=2 WHERE `id`=1; |
|
60 |
COMMIT; |
|
61 |
START TRANSACTION; |
|
62 |
DELETE FROM `test`.`t1` WHERE `id`=2; |
|
63 |
DELETE FROM `test`.`t2` WHERE `id`=2; |
|
64 |
COMMIT; |
|
65 |
START TRANSACTION; |
|
66 |
DROP TABLE `test`.`t1`; |
|
67 |
COMMIT; |
|
68 |
START TRANSACTION; |
|
69 |
DROP TABLE `test`.`t2`; |
|
70 |
COMMIT; |
|
|
1662.3.3
by Joe Daly
add new test for multi table updates within a transaction |
71 |
SET GLOBAL transaction_log_truncate_debug= true; |