← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/extra/rpl_tests/rpl_multi_update.test

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/extra/rpl_tests/rpl_multi_update.test
 
1
source include/master-slave.inc;
 
2
 
 
3
eval CREATE TABLE t1 (
 
4
 a int unsigned not null auto_increment primary key,
 
5
 b int unsigned
 
6
) ENGINE=$engine_type;
 
7
 
 
8
eval CREATE TABLE t2 (
 
9
 a int unsigned not null auto_increment primary key,
 
10
 b int unsigned
 
11
) ENGINE=$engine_type;
 
12
 
 
13
INSERT INTO t1 VALUES (NULL, 0);
 
14
INSERT INTO t1 SELECT NULL, 0 FROM t1;
 
15
 
 
16
INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
 
17
 
 
18
SELECT * FROM t1 ORDER BY a;
 
19
SELECT * FROM t2 ORDER BY a;
 
20
 
 
21
UPDATE t1, t2 SET t1.b = t2.b WHERE t1.a = t2.a;
 
22
save_master_pos;
 
23
connection slave;
 
24
sync_with_master;
 
25
 
 
26
# End of 4.1 tests
 
27
 
 
28
connection master;
 
29
drop table t1, t2;
 
30
sync_slave_with_master;