diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_name_const.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_name_const.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_name_const.result b/mysql-test/suite/rpl/r/rpl_name_const.result new file mode 100644 index 00000000..7e91cf47 --- /dev/null +++ b/mysql-test/suite/rpl/r/rpl_name_const.result @@ -0,0 +1,25 @@ +include/master-slave.inc +[connection master] +==== Initialize ==== +connection 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); +connection slave; +select * from t1 order by id; +id +1234 +==== Clean up ==== +connection master; +drop table t1; +drop procedure test_procedure; +include/rpl_end.inc |