Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 CALL mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT');
4 CREATE TABLE t1 (a VARCHAR(1000));
5 INSERT INTO t1 VALUES (CONNECTION_ID());
6 connection master1;
7 INSERT INTO t1 VALUES (CONNECTION_ID());
8 INSERT INTO t1 VALUES
9 (CURDATE()),
10 (CURRENT_DATE()),
11 (CURRENT_TIME()),
12 (CURRENT_TIMESTAMP()),
13 (CURTIME()),
14 (LOCALTIME()),
15 (LOCALTIMESTAMP()),
16 (NOW()),
17 (UNIX_TIMESTAMP()),
18 (UTC_DATE()),
19 (UTC_TIME()),
20 (UTC_TIMESTAMP());
21 INSERT INTO t1 VALUES (RAND());
22 INSERT INTO t1 VALUES (LAST_INSERT_ID());
23 connection slave;
24 include/diff_tables.inc [master:t1, slave:t1]
25 connection master;
26 DROP TABLE t1;
27 include/rpl_end.inc