|
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; |
|
|
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. |
9 |
START TRANSACTION; |
|
1308.2.4
by Jay Pipes
Adds DROP TABLE to the list of non RAW_SQL statements in replication stream |
10 |
DROP TABLE IF EXISTS `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. |
11 |
COMMIT; |
12 |
START TRANSACTION; |
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
13 |
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, PRIMARY KEY (`id`) ) 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. |
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 (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. |
17 |
COMMIT; |
18 |
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() |
19 |
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. |
20 |
COMMIT; |
21 |
START TRANSACTION; |
|
|
1308.2.4
by Jay Pipes
Adds DROP TABLE to the list of non RAW_SQL statements in replication stream |
22 |
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. |
23 |
COMMIT; |
|
1193.2.1
by Joe Daly
add new tests for create table with select, update with a subquery, and a call to rand() |
24 |
SET GLOBAL transaction_log_truncate_debug= true; |