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