← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

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

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
Merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/alter.result
10
10
ALTER TABLE t1 ADD INDEX ix_padding (padding(20));
11
11
DROP TABLE t1;
12
12
START TRANSACTION;
13
 
DROP TABLE IF EXISTS `t1`;
 
13
DROP TABLE IF EXISTS `test`.`t1`;
14
14
COMMIT;
15
15
START TRANSACTION;
16
 
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL , PRIMARY KEY (id) );
 
16
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;
17
17
COMMIT;
18
18
START TRANSACTION;
19
19
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
28
28
ALTER TABLE t1 ADD INDEX ix_padding (padding(20));
29
29
COMMIT;
30
30
START TRANSACTION;
31
 
DROP TABLE `t1`;
 
31
DROP TABLE `test`.`t1`;
32
32
COMMIT;
33
33
SET GLOBAL transaction_log_truncate_debug= true;