Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_row_NOW.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 create database if not exists mysqltest1;
5 DROP TABLE IF EXISTS mysqltest1.t1;
6 CREATE TABLE mysqltest1.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT,
7 a TIMESTAMP DEFAULT '2005-05-05 01:01:01',
8 b TIMESTAMP DEFAULT '2005-05-05 01:01:01',
9 PRIMARY KEY(n));
10 CREATE FUNCTION mysqltest1.f1() RETURNS TIMESTAMP
11 BEGIN
12 DECLARE v1 INT DEFAULT 300;
13 WHILE v1 > 0 DO
14 SET v1 = v1 - 1;
15 END WHILE;
16 RETURN NOW();
17 END|
18 INSERT INTO mysqltest1.t1 VALUES(NULL,NOW(),mysqltest1.f1());
19 CREATE TRIGGER mysqltest1.trig1 BEFORE INSERT ON mysqltest1.t1
20 FOR EACH ROW BEGIN
21 SET new.b = mysqltest1.f1();
22 END|
23 INSERT INTO mysqltest1.t1 SET n = NULL, a = now();
24 connection slave;
25 connection master;
26 DROP TABLE IF EXISTS mysqltest1.t1;
27 DROP FUNCTION mysqltest1.f1;
28 DROP DATABASE mysqltest1;
29 connection slave;
30 include/rpl_end.inc