rpl000004.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- source include/master-slave.inc;
- set SQL_LOG_BIN=0;
- create table t1 (word char(20) not null, index(word));
- load data infile '../../std_data/words.dat' into table t1;
- create table t2 (word char(20) not null);
- load data infile '../../std_data/words.dat' into table t2;
- create table t3 (word char(20) not null primary key);
- connection slave;
- load table t1 from master;
- load table t2 from master;
- load table t3 from master;
- check table t1;
- select count(*) from t2;
- select count(*) from t3;
- connection master;
- set SQL_LOG_BIN=1;
- drop table if exists t1,t2,t3;
- save_master_pos;
- connection slave;
- sync_with_master;
- create table t1(n int);
- drop table t1;
- # End of 4.1 tests