← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2011-07-15 08:26:31 UTC
  • mto: (2392.1.1 drizzle-autoconf)
  • mto: This revision was merged to the branch mainline in revision 2369.
  • Revision ID: brian@tangent.org-20110715082631-y8oo7j1aug8nwlym
https://launchpad.net/bugs/798940
This patch fixes 798940, we will also just now add the type of index to our create statements.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/insert.result
7
7
INSERT INTO t1 VALUES (2, "I hate testing.");
8
8
DROP TABLE t1;
9
9
SET AUTOCOMMIT=0;
10
 
CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
10
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;
11
11
COMMIT;
12
12
START TRANSACTION;
13
13
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
21
21
 
22
22
Generating statements for innodb replication log
23
23
SET AUTOCOMMIT=0;
24
 
CREATE TABLE `test`.`t1` (   `id` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
24
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;
25
25
COMMIT;
26
26
START TRANSACTION;
27
27
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');