Debian Codegraph @

mysql-test/suite/rpl/r/rpl_name_const.result

raw
1 include/master-slave.inc
2 [connection master]
3 ==== Initialize ====
4 connection master;
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)
9 begin
10 insert into t1 (id)
11 select a.id
12 from
13 ( select _id as id ) a;
14 end;$$
15 ==== enable the binary log, then call the procedure ====
16 call test_procedure(1234);
17 connection slave;
18 select * from t1 order by id;
19 id
20 1234
21 ==== Clean up ====
22 connection master;
23 drop table t1;
24 drop procedure test_procedure;
25 include/rpl_end.inc