mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
30 lines
854 B
Text
30 lines
854 B
Text
include/master-slave.inc
|
|
[connection master]
|
|
connection master;
|
|
create database if not exists mysqltest1;
|
|
DROP TABLE IF EXISTS mysqltest1.t1;
|
|
CREATE TABLE mysqltest1.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT,
|
|
a TIMESTAMP DEFAULT '2005-05-05 01:01:01',
|
|
b TIMESTAMP DEFAULT '2005-05-05 01:01:01',
|
|
PRIMARY KEY(n));
|
|
CREATE FUNCTION mysqltest1.f1() RETURNS TIMESTAMP
|
|
BEGIN
|
|
DECLARE v1 INT DEFAULT 300;
|
|
WHILE v1 > 0 DO
|
|
SET v1 = v1 - 1;
|
|
END WHILE;
|
|
RETURN NOW();
|
|
END|
|
|
INSERT INTO mysqltest1.t1 VALUES(NULL,NOW(),mysqltest1.f1());
|
|
CREATE TRIGGER mysqltest1.trig1 BEFORE INSERT ON mysqltest1.t1
|
|
FOR EACH ROW BEGIN
|
|
SET new.b = mysqltest1.f1();
|
|
END|
|
|
INSERT INTO mysqltest1.t1 SET n = NULL, a = now();
|
|
connection slave;
|
|
connection master;
|
|
DROP TABLE IF EXISTS mysqltest1.t1;
|
|
DROP FUNCTION mysqltest1.f1;
|
|
DROP DATABASE mysqltest1;
|
|
connection slave;
|
|
include/rpl_end.inc
|