Debian Codegraph @

mysql-test/suite/rpl/r/rpl_ps.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 drop table if exists t1;
7 create table t1(n char(30));
8 prepare stmt1 from 'insert into t1 values (?)';
9 set @var1= "from-master-1";
10 execute stmt1 using @var1;
11 set @var1= "from-master-2-'',";
12 execute stmt1 using @var1;
13 SELECT * FROM t1 ORDER BY n;
14 n
15 from-master-1
16 from-master-2-'',
17 set @var2= 'insert into t1 values (concat("from-var-", ?))';
18 prepare stmt2 from @var2;
19 set @var1='from-master-3';
20 execute stmt2 using @var1;
21 include/sync_slave_sql_with_master.inc
22 SELECT * FROM t1 ORDER BY n;
23 n
24 from-master-1
25 from-master-2-'',
26 from-var-from-master-3
27 drop table t1;
28 include/sync_slave_sql_with_master.inc
29 stop slave;
30 Warnings:
31 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
32 include/wait_for_slave_to_stop.inc
33
34 ########################################################################
35 #
36 # BUG#25843: Changing default database between PREPARE and EXECUTE of
37 # statement breaks binlog.
38 #
39 ########################################################################
40 # Connection: slave
41 START SLAVE;
42 Warnings:
43 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
44 # Connection: master
45 CREATE DATABASE mysqltest1;
46 CREATE TABLE t1(db_name CHAR(32), db_col_name CHAR(32));
47 PREPARE stmt_d_1 FROM 'INSERT INTO t1 VALUES(DATABASE(), @@collation_database)';
48 EXECUTE stmt_d_1;
49 use mysqltest1;
50 EXECUTE stmt_d_1;
51 # Connection: slave
52 include/sync_slave_sql_with_master.inc
53 SELECT * FROM t1;
54 db_name db_col_name
55 test utf8mb4_0900_ai_ci
56 test utf8mb4_0900_ai_ci
57 # Connection: master
58 DROP DATABASE mysqltest1;
59 use test;
60 DROP TABLE t1;
61 include/rpl_end.inc