← Back to branch summary

~drizzle-developers/drizzle/elliott-release

« back to all changes in this revision

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

  • Committer: Patrick Crews
  • Date: 2011-02-01 20:33:06 UTC
  • mfrom: (1845.2.288 drizzle)
  • Revision ID: gleebix@gmail.com-20110201203306-mwq2rk0it81tlwxh
Merged Trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/select_for_update.result
24
24
COMMIT;
25
25
DROP TABLE t1;
26
26
SET GLOBAL innodb_lock_wait_timeout=@orig_lock_wait_timeout ;
27
 
START TRANSACTION;
 
27
SET AUTOCOMMIT=0;
28
28
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;
29
29
COMMIT;
30
30
START TRANSACTION;
41
41
UPDATE `test`.`t1` SET `id`=4 WHERE `id`=3;
42
42
UPDATE `test`.`t1` SET `id`=6 WHERE `id`=5;
43
43
COMMIT;
44
 
START TRANSACTION;
 
44
SET AUTOCOMMIT=0;
45
45
DROP TABLE `test`.`t1`;
46
46
COMMIT;
47
47
 
48
48
Generating statements for innodb replication log
49
 
START TRANSACTION;
 
49
SET AUTOCOMMIT=0;
50
50
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;
51
51
COMMIT;
52
52
START TRANSACTION;
63
63
UPDATE `test`.`t1` SET `id`=4 WHERE `id`=3;
64
64
UPDATE `test`.`t1` SET `id`=6 WHERE `id`=5;
65
65
COMMIT;
66
 
START TRANSACTION;
 
66
SET AUTOCOMMIT=0;
67
67
DROP TABLE `test`.`t1`;
68
68
COMMIT;
69
69
SET GLOBAL transaction_log_truncate_debug= true;