EVOLUTION-MANAGER

Edit File: rpl_name_const.test

# ==== Purpose ==== # # Test that aliases of variables in binary log aren't ignored with NAME_CONST. # # ==== Method ==== # # Create a procedure with aliases of variables, then replicate it to slave. # BUG#35515 Aliases of variables in binary log are ignored with NAME_CONST. # source include/master-slave.inc; --echo ==== Initialize ==== --connection master create table t1 (id int); --echo ==== create a procedure that has a column aliase in a subquery ==== --disable_warnings drop procedure if exists test_procedure; --enable_warnings delimiter $$; create procedure test_procedure(_id int) begin insert into t1 (id) select a.id from ( select _id as id ) a; end;$$ delimiter ;$$ --echo ==== enable the binary log, then call the procedure ==== call test_procedure(1234); sync_slave_with_master; select * from t1 order by id; --echo ==== Clean up ==== connection master; drop table t1; drop procedure test_procedure; --source include/rpl_end.inc