~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/insert.result

  • Committer: Padraig O'Sullivan
  • Date: 2010-04-17 01:38:47 UTC
  • mfrom: (1237.9.238 bad-staging)
  • Revision ID: osullivan.padraig@gmail.com-20100417013847-ibjioqsfbmf5yg4g
Merge trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
5
5
);
6
6
INSERT INTO t1 VALUES (1, "I love testing.");
7
7
INSERT INTO t1 VALUES (2, "I hate testing.");
 
8
DROP TABLE t1;
8
9
START TRANSACTION;
9
10
DROP TABLE IF EXISTS `test`.`t1`;
10
11
COMMIT;
11
12
START TRANSACTION;
12
 
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;
 
13
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
13
14
COMMIT;
14
15
START TRANSACTION;
15
16
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
17
18
START TRANSACTION;
18
19
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.');
19
20
COMMIT;
 
21
START TRANSACTION;
 
22
DROP TABLE `test`.`t1`;
 
23
COMMIT;
20
24
SET GLOBAL transaction_log_truncate_debug= true;