mirror of
https://github.com/MariaDB/server.git
synced 2025-09-11 05:52:26 +03:00
33 lines
517 B
Plaintext
33 lines
517 B
Plaintext
include/master-slave.inc
|
|
[connection master]
|
|
connection master;
|
|
DROP FUNCTION test.f1;
|
|
DROP TABLE IF EXISTS test.t1;
|
|
create table test.t1 (a int, PRIMARY KEY(a));
|
|
create function test.f1(i int) returns int
|
|
begin
|
|
insert into test.t1 values(i);
|
|
return 0;
|
|
end//
|
|
select test.f1(1);
|
|
test.f1(1)
|
|
0
|
|
select test.f1(2);
|
|
test.f1(2)
|
|
0
|
|
select * from test.t1;
|
|
a
|
|
1
|
|
2
|
|
connection slave;
|
|
connection slave;
|
|
select * from test.t1;
|
|
a
|
|
1
|
|
2
|
|
connection master;
|
|
DROP FUNCTION test.f1;
|
|
DROP TABLE test.t1;
|
|
connection slave;
|
|
include/rpl_end.inc
|