Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_func002.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP FUNCTION test.f1;
5 DROP TABLE IF EXISTS test.t1;
6 DROP TABLE IF EXISTS test.t2;
7 CREATE TABLE test.t1 (a INT NOT NULL AUTO_INCREMENT, t TIMESTAMP, t2 TIMESTAMP, PRIMARY KEY(a));
8 CREATE TABLE test.t2 (a INT NOT NULL AUTO_INCREMENT, t TIMESTAMP, t2 TIMESTAMP, PRIMARY KEY(a));
9 create function test.f1() RETURNS TIMESTAMP
10 BEGIN
11 UPDATE test.t1 SET t = CURRENT_TIMESTAMP;
12 RETURN CURRENT_TIMESTAMP;
13 END//
14 INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP);
15 SET TIMESTAMP=2;
16 INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP);
17 SET TIMESTAMP=1;
18 INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP);
19 SET TIMESTAMP=333300000;
20 INSERT INTO test.t2 VALUES (null,f1(),CURRENT_TIMESTAMP);
21 connection slave;
22 connection master;
23 DROP FUNCTION test.f1;
24 DROP TABLE test.t1;
25 DROP TABLE test.t2;
26 connection slave;
27 include/rpl_end.inc