Edit File: rpl_name_const.result
include/master-slave.inc [connection master] ==== Initialize ==== [on master] create table t1 (id int); ==== create a procedure that has a column aliase in a subquery ==== drop procedure if exists test_procedure; create procedure test_procedure(_id int) begin insert into t1 (id) select a.id from ( select _id as id ) a; end;$$ ==== enable the binary log, then call the procedure ==== call test_procedure(1234); [on slave] select * from t1 order by id; id 1234 ==== Clean up ==== [on master] drop table t1; drop procedure test_procedure; include/rpl_end.inc
Back to File Manager