1include/master-slave.inc 2[connection master] 3connection slave; 4select @@secure_timestamp; 5@@secure_timestamp 6YES 7set timestamp=1234567890.101112; 8ERROR HY000: The MariaDB server is running with the --secure-timestamp=YES option so it cannot execute this statement 9select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'SUPER'; 10SUPER 11READONLY 12create user foo@127.0.0.1; 13connect con2,127.0.0.1,foo,,test,$SLAVE_MYPORT; 14set timestamp=1234567890.101112; 15ERROR HY000: The MariaDB server is running with the --secure-timestamp=YES option so it cannot execute this statement 16select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'non-privileged'; 17non-privileged 18READONLY 19disconnect con2; 20connection slave; 21drop user foo@127.0.0.1; 22connection master; 23set time_zone='+00:00'; 24set timestamp=1234567890.101112; 25select @@timestamp, now(6); 26@@timestamp now(6) 271234567890.101112 2009-02-13 23:31:30.101112 28create table t1 (b varchar(20), a timestamp(6) default current_timestamp(6)); 29insert t1 (b) values ('replicated'); 30connection slave; 31create trigger t1rbr before insert on t1 for each row set new.a=now(6); 32set @@global.slave_run_triggers_for_rbr= yes; 33binlog 'LQfqWg8BAAAA/AAAAAABAAABAAQAMTAuMy42LU1hcmlhREItZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAtB+paEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEwQADQgICAoKCgFlBcaR'; 34binlog '0gKWSRMBAAAAMQAAAHQDAAAAAB8AAAAAAAEABHRlc3QAAnQxAAIPEQMUAAYBQFUzwA==0gKWSRcBAAAAMAAAAKQDAAAAAB8AAAAAAAEAAv/8BmJpbmxvZ0mWAtIBivg3mwo+'; 35set @@global.slave_run_triggers_for_rbr= default; 36select b, if(a > 20100101, 'READONLY', 'EDITABLE') as 'REPLICATION' from t1; 37b REPLICATION 38replicated READONLY 39binlog READONLY 40connection master; 41drop table t1; 42include/rpl_end.inc 43