|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
1 |
DROP TABLE IF EXISTS t1; |
2 |
CREATE TABLE t1 ( |
|
3 |
id INT NOT NULL |
|
4 |
, PRIMARY KEY (id) |
|
5 |
);
|
|
|
1143.2.37
by Jay Pipes
Merge Joe's new test cases for transaction log |
6 |
INSERT INTO t1 VALUES (1); |
7 |
INSERT INTO t1 SELECT RAND(100)*100 FROM t1; |
|
8 |
DROP TABLE t1; |
|
|
2092.1.1
by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. |
9 |
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. |
10 |
CREATE TABLE `test`.`t1` ( `id` 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. |
11 |
COMMIT; |
12 |
START TRANSACTION; |
|
|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
13 |
INSERT INTO `test`.`t1` (`id`) VALUES (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. |
14 |
COMMIT; |
15 |
START TRANSACTION; |
|
|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
16 |
INSERT INTO `test`.`t1` (`id`) VALUES (17); |
|
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. |
17 |
COMMIT; |
|
2092.1.1
by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. |
18 |
SET AUTOCOMMIT=0; |
|
1308.2.4
by Jay Pipes
Adds DROP TABLE to the list of non RAW_SQL statements in replication stream |
19 |
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. |
20 |
COMMIT; |
|
1802.17.17
by Joseph Daly
port additional tests |
21 |
|
22 |
Generating statements for innodb replication log |
|
|
2092.1.1
by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. |
23 |
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. |
24 |
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci; |
|
1802.17.17
by Joseph Daly
port additional tests |
25 |
COMMIT; |
26 |
START TRANSACTION; |
|
27 |
INSERT INTO `test`.`t1` (`id`) VALUES (1); |
|
28 |
COMMIT; |
|
29 |
START TRANSACTION; |
|
30 |
INSERT INTO `test`.`t1` (`id`) VALUES (17); |
|
31 |
COMMIT; |
|
|
2092.1.1
by David Shrewsbury
Use AUTOCOMMIT=0 with DDL output from transaction_reader. |
32 |
SET AUTOCOMMIT=0; |
|
1802.17.17
by Joseph Daly
port additional tests |
33 |
DROP TABLE `test`.`t1`; |
34 |
COMMIT; |
|
|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
35 |
SET GLOBAL transaction_log_truncate_debug= true; |