← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/multi_column_primary_key.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/multi_column_primary_key.result
15
15
UPDATE t1 SET padding= "AAA";
16
16
DROP TABLE t1;
17
17
SET AUTOCOMMIT=0;
18
 
CREATE TABLE `test`.`t1` (   `k1` INT NOT NULL,   `k2` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`k1`,`k2`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
18
CREATE TABLE `test`.`t1` (   `k1` INT NOT NULL,   `k2` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`k1`,`k2`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
19
19
COMMIT;
20
20
START TRANSACTION;
21
21
INSERT INTO `test`.`t1` (`k1`,`k2`,`padding`) VALUES (1,1,'I love testing.');
52
52
 
53
53
Generating statements for innodb replication log
54
54
SET AUTOCOMMIT=0;
55
 
CREATE TABLE `test`.`t1` (   `k1` INT NOT NULL,   `k2` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`k1`,`k2`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
 
55
CREATE TABLE `test`.`t1` (   `k1` INT NOT NULL,   `k2` INT NOT NULL,   `padding` VARCHAR(200) COLLATE utf8_general_ci NOT NULL,   PRIMARY KEY (`k1`,`k2`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
56
56
COMMIT;
57
57
START TRANSACTION;
58
58
INSERT INTO `test`.`t1` (`k1`,`k2`,`padding`) VALUES (1,1,'I love testing.');