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/master-slave.inc
12
13
14 # Begin clean up test section
15 connection master;
16 --disable_warnings
17 --error 0,1305
18 DROP FUNCTION test.f1;
19 DROP TABLE IF EXISTS test.t1;
20
21
22 --enable_warnings
23
24 # Section 1 test from bug #12487 Uses stored function to insert rows to see what is replicated.
25
26 create table test.t1 (a int, PRIMARY KEY(a));
27
28 delimiter //;
29 create function test.f1(i int) returns int
30 begin
31 insert into test.t1 values(i);
32 return 0;
33 end//
34 delimiter ;//
35
36 --disable_ps2_protocol
37 select test.f1(1);
38 select test.f1(2);
39 --enable_ps2_protocol
40 select * from test.t1;
41
42 save_master_pos;
43 sync_slave_with_master;
44 connection slave;
45 #show create table test.t1;
46 select * from test.t1;
47
48 connection master;
49
50 #Used for debugging
51 #show binlog events;
52
53 # Cleanup
54
55 DROP FUNCTION test.f1;
56 DROP TABLE test.t1;
57 sync_slave_with_master;
58
59 # End of 5.0 test case
60 --source include/rpl_end.inc