~james-page/ubuntu/precise/mysql-5.5/misc-fixes

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_row_merge_engine.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-06-11 07:34:33 UTC
  • mfrom: (1.1.6)
  • Revision ID: package-import@ubuntu.com-20120611073433-l9za2ni4ipp848y3
Tags: 5.5.24-0ubuntu0.12.04.1
* SECURITY UPDATE: Update to 5.5.24 to fix security issues (LP: #1011371)
  - http://dev.mysql.com/doc/refman/5.5/en/news-5-5-24.html

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
include/master-slave.inc
 
2
[connection master]
 
3
CREATE TABLE t1 (a int) ENGINE=MyISAM;
 
4
CREATE TABLE t2 (a int) ENGINE=MyISAM;
 
5
INSERT INTO t1 VALUES (1), (2), (3);
 
6
INSERT INTO t2 VALUES (4), (5), (6);
 
7
CREATE TABLE IF NOT EXISTS t1_merge LIKE t1;
 
8
ALTER TABLE t1_merge ENGINE=MERGE UNION (t2, t1);
 
9
include/diff_tables.inc [master:test.t1, slave:test.t1]
 
10
include/diff_tables.inc [master:test.t2, slave:test.t2]
 
11
UPDATE t1_merge SET a=10 WHERE a=1;
 
12
DELETE FROM t1_merge WHERE a=10;
 
13
include/diff_tables.inc [master:test.t1, slave:test.t1]
 
14
include/diff_tables.inc [master:test.t2, slave:test.t2]
 
15
DROP TABLE t1_merge, t1, t2;
 
16
include/rpl_end.inc