• monty@mashka.mysql.fi's avatar
    Small improvement to alloc_root · 1a96948e
    monty@mashka.mysql.fi authored
    Add support for LIMIT # OFFSET #
    Changed lock handling:  Now all locks should be stored in TABLE_LIST instead of passed to functions.
    Don't call query_cache_invalidate() twice in some cases
    mysql_change_user() now clears states to be equal to close + connect.
    Fixed a bug with multi-table-update and multi-table-delete when used with LOCK TABLES
    Fixed a bug with replicate-do and UPDATE
    1a96948e
rpl_replicate_do.test 760 Bytes
# This test assumes we are ignoring updates on table t2, but doing
# updates on t1

source include/master-slave.inc;
drop table if exists t11;
connection slave;
drop table if exists t11;
create table t2 (n int);
insert into t2 values(4);
connection master;
create table t2 (s char(20));
load data infile '../../std_data/words.dat' into table t2;
insert into t2 values('five');
create table t1 (m int);
insert into t1 values(15),(16),(17);
update t1 set m=20 where m=16;
delete from t1 where m=17;
create table t11 select * from t1;
save_master_pos;
connection slave;
sync_with_master;
select * from t1;
select * from t2;
--error 1146
select * from t11;
connection master;
drop table if exists t1,t2,t3,t11;
save_master_pos;
connection slave;
sync_with_master;