1 include/master-slave.inc
5 create table t1 (id int);
6 ==== create a procedure that has a column aliase in a subquery ====
7 drop procedure if exists test_procedure;
8 create procedure test_procedure(_id int)
13 ( select _id as id ) a;
15 ==== enable the binary log, then call the procedure ====
16 call test_procedure(1234);
18 select * from t1 order by id;
24 drop procedure test_procedure;