rpl_ps.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- #
- # Test of replicating user variables
- #
- source include/master-slave.inc;
- #save_master_pos;
- #connection slave;
- #sync_with_master;
- #reset master;
- #connection master;
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- create table t1(n char(30));
- prepare stmt1 from 'insert into t1 values (?)';
- set @var1= "from-master-1";
- execute stmt1 using @var1;
- set @var1= "from-master-2-'',";
- execute stmt1 using @var1;
- select * from t1;
- set @var2= 'insert into t1 values (concat("from-var-", ?))';
- prepare stmt2 from @var2;
- set @var1='from-master-3';
- execute stmt2 using @var1;
- save_master_pos;
- connection slave;
- sync_with_master;
- select * from t1;
- connection master;
- drop table t1;
- save_master_pos;
- connection slave;
- sync_with_master;
- stop slave;
- # End of 4.1 tests