22
22
insert into t1 values(4, connection_id(), rand()*1000, rand()*1000, password('does_this_still_work?'));
23
23
select * into outfile 'rpl_misc_functions.outfile' from t1;
26
27
# read the values from the master table
29
30
# compare them with the replica; the SELECT below should return no row
30
31
select * from t1, t2 where (t1.id=t2.id) and not(t1.i=t2.i and t1.r1=t2.r1 and t1.r2=t2.r2 and t1.p=t2.p);