← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Eric Day
  • Date: 2010-03-05 18:36:33 UTC
  • mfrom: (1324 staging)
  • mto: This revision was merged to the branch mainline in revision 1329.
  • Revision ID: eday@oddments.org-20100305183633-r765knk80hjjmfpj
Merged 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;