Debian Codegraph @

mysql-test/suite/rpl/r/rpl_insert_ignore_myisam.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 CREATE TABLE t1 (
8 a int unsigned not null auto_increment primary key,
9 b int unsigned,
10 unique (b)
11 ) ENGINE=myisam;
12 CREATE TABLE t2 (
13 a int unsigned, # to force INSERT SELECT to have a certain order
14 b int unsigned
15 ) ENGINE=myisam;
16 INSERT INTO t1 VALUES (NULL, 1);
17 INSERT INTO t1 VALUES (NULL, 2);
18 INSERT INTO t1 VALUES (NULL, 3);
19 INSERT INTO t1 VALUES (NULL, 4);
20 INSERT INTO t2 VALUES (1, 1);
21 INSERT INTO t2 VALUES (2, 2);
22 INSERT INTO t2 VALUES (3, 5);
23 INSERT INTO t2 VALUES (4, 3);
24 INSERT INTO t2 VALUES (5, 4);
25 INSERT INTO t2 VALUES (6, 6);
26 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
27 include/assert.inc [Count of elements in t1 should be 6.]
28 include/sync_slave_sql_with_master.inc
29 include/diff_tables.inc [master:test.t1 , slave:test.t1]
30 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
31 include/assert.inc [Count of elements in t1 should be 6.]
32 include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]
33 DROP TABLE t1;
34 DROP TABLE t2;
35 CREATE TABLE t1 (
36 a INT UNSIGNED NOT NULL PRIMARY KEY
37 ) ENGINE=myisam;
38 CREATE TABLE t2 (
39 a INT UNSIGNED
40 ) ENGINE=myisam;
41 INSERT INTO t1 VALUES (1);
42 INSERT INTO t2 VALUES (1);
43 INSERT INTO t1 SELECT t2.a FROM t2 ORDER BY t2.a ON DUPLICATE KEY UPDATE t1.a= t1.a;
44 include/assert.inc [Sum of elements in t1 should be 1.]
45 include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]
46 drop table t1, t2;
47 include/sync_slave_sql_with_master.inc
48 include/rpl_end.inc