1 include/master-slave.inc
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;
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 SELECT * FROM t1 ORDER BY n;
22 from-var-from-master-3
26 ########################################################################
28 # BUG#25843: Changing default database between PREPARE and EXECUTE of
29 # statement breaks binlog.
31 ########################################################################
35 CREATE DATABASE mysqltest1;
36 CREATE TABLE t1(db_name CHAR(32), db_col_name CHAR(32));
37 PREPARE stmt_d_1 FROM 'INSERT INTO t1 VALUES(DATABASE(), @@collation_database)';
44 test latin1_swedish_ci
45 test latin1_swedish_ci
47 DROP DATABASE mysqltest1;