← Back to branch summary

~stewart/drizzle/embedded-innodb-create-table-with-index

« back to all changes in this revision

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

  • Committer: Stewart Smith
  • Date: 2010-03-11 01:15:57 UTC
  • mfrom: (1319.1.29)
  • Revision ID: stewart@flamingspork.com-20100311011557-49r2ye69bqh4abti
Merged embedded-innodb-rnd-read into embedded-innodb-create-table-with-index.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/select_for_update.result
19
19
COMMIT;
20
20
DROP TABLE t1;
21
21
START TRANSACTION;
22
 
DROP TABLE IF EXISTS `t1`;
 
22
DROP TABLE IF EXISTS `test`.`t1`;
23
23
COMMIT;
24
24
START TRANSACTION;
25
 
CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL , PRIMARY KEY (id) );
 
25
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;
26
26
COMMIT;
27
27
START TRANSACTION;
28
28
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');
39
39
UPDATE `test`.`t1` SET `id`=6 WHERE `id`=5;
40
40
COMMIT;
41
41
START TRANSACTION;
42
 
DROP TABLE `t1`;
 
42
DROP TABLE `test`.`t1`;
43
43
COMMIT;
44
44
SET GLOBAL transaction_log_truncate_debug= true;