Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_func001.test

raw
1 #############################################################################
2 # This test is being created to test out the non deterministic items with #
3 # row based replication. #
4 # Original Author: JBM #
5 # Original Date: Aug/10/2005 #
6 # Update: 08/29/2005 change name to initails #
7 #############################################################################
8
9 # Includes
10 -- source include/have_binlog_format_row.inc
11 -- source include/set_privilege_checks_user_as_system_user.inc
12 -- source include/master-slave.inc
13
14
15 # Begin clean up test section
16 connection master;
17 --disable_warnings
18 --error 0,1305
19 DROP FUNCTION test.f1;
20 DROP TABLE IF EXISTS test.t1;
21
22
23 --enable_warnings
24
25 # Section 1 test from bug #12487 Uses stored function to insert rows to see what is replicated.
26
27 create table test.t1 (a int, PRIMARY KEY(a));
28
29 delimiter //;
30 create function test.f1(i int) returns int
31 begin
32 insert into test.t1 values(i);
33 return 0;
34 end//
35 delimiter ;//
36
37 select test.f1(1);
38 select test.f1(2);
39 select * from test.t1;
40
41 save_master_pos;
42 --source include/sync_slave_sql_with_master.inc
43 connection slave;
44 #show create table test.t1;
45 select * from test.t1;
46
47 connection master;
48
49 #Used for debugging
50 #show binlog events;
51
52 # Cleanup
53
54 DROP FUNCTION test.f1;
55 DROP TABLE test.t1;
56 --source include/sync_slave_sql_with_master.inc
57
58 # End of 5.0 test case
59 --source include/rpl_end.inc