Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_ps.result

raw
1 include/master-slave.inc
2 [connection master]
3 drop table if exists t1;
4 create table t1(n char(30));
5 prepare stmt1 from 'insert into t1 values (?)';
6 set @var1= "from-master-1";
7 execute stmt1 using @var1;
8 set @var1= "from-master-2-'',";
9 execute stmt1 using @var1;
10 SELECT * FROM t1 ORDER BY n;
11 n
12 from-master-1
13 from-master-2-'',
14 set @var2= 'insert into t1 values (concat("from-var-", ?))';
15 prepare stmt2 from @var2;
16 set @var1='from-master-3';
17 execute stmt2 using @var1;
18 connection slave;
19 SELECT * FROM t1 ORDER BY n;
20 n
21 from-master-1
22 from-master-2-'',
23 from-var-from-master-3
24 connection master;
25 drop table t1;
26 connection slave;
27 stop slave;
28 include/wait_for_slave_to_stop.inc
29
30 ########################################################################
31 #
32 # BUG#25843: Changing default database between PREPARE and EXECUTE of
33 # statement breaks binlog.
34 #
35 ########################################################################
36 connection slave;
37 START SLAVE;
38 connection master;
39 CREATE DATABASE mysqltest1;
40 CREATE TABLE t1(db_name CHAR(32), db_col_name CHAR(32));
41 PREPARE stmt_d_1 FROM 'INSERT INTO t1 VALUES(DATABASE(), @@collation_database)';
42 EXECUTE stmt_d_1;
43 use mysqltest1;
44 EXECUTE stmt_d_1;
45 connection slave;
46 SELECT * FROM t1;
47 db_name db_col_name
48 test utf8mb4_uca1400_ai_ci
49 test utf8mb4_uca1400_ai_ci
50 connection master;
51 DROP DATABASE mysqltest1;
52 use test;
53 DROP TABLE t1;
54 include/rpl_end.inc