Debian Codegraph @

mysql-test/suite/sys_vars/r/secure_timestamp_rpl.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 select @@secure_timestamp;
5 @@secure_timestamp
6 REPLICATION
7 ### ALL PRIVILEGES
8 set timestamp=1234567890.101112;
9 select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'ALL PRIVILEGES';
10 ALL PRIVILEGES
11 EDITABLE
12 set timestamp=default;
13 ### SUPER
14 create user [email protected];
15 grant super on *.* TO `foo`@`127.0.0.1`;
16 connect con2,127.0.0.1,foo,,"*NO-ONE*",$SLAVE_MYPORT;
17 set timestamp=1234567890.101112;
18 ERROR 42000: Access denied; you need (at least one of) the BINLOG REPLAY privilege(s) for this operation
19 select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'SUPER';
20 SUPER
21 READONLY
22 disconnect con2;
23 connection slave;
24 drop user [email protected];
25 set timestamp=default;
26 ### BINLOG REPLAY
27 create user [email protected];
28 grant binlog replay on *.* TO `foo`@`127.0.0.1`;
29 connect con2,127.0.0.1,foo,,"*NO-ONE*",$SLAVE_MYPORT;
30 set timestamp=1234567890.101112;
31 select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'BINLOG REPLAY';
32 BINLOG REPLAY
33 EDITABLE
34 disconnect con2;
35 connection slave;
36 drop user [email protected];
37 set timestamp=default;
38 ### non-privileged user
39 create user [email protected];
40 connect con2,127.0.0.1,foo,,"*NO-ONE*",$SLAVE_MYPORT;
41 set timestamp=1234567890.101112;
42 ERROR 42000: Access denied; you need (at least one of) the BINLOG REPLAY privilege(s) for this operation
43 select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'non-privileged';
44 non-privileged
45 READONLY
46 disconnect con2;
47 connection slave;
48 drop user [email protected];
49 set timestamp=default;
50 connection master;
51 set time_zone='+00:00';
52 set timestamp=1234567890.101112;
53 select @@timestamp, now(6);
54 @@timestamp now(6)
55 1234567890.101112 2009-02-13 23:31:30.101112
56 create table t1 (b varchar(20), a timestamp(6) default current_timestamp(6)) charset=latin1;
57 insert t1 (b) values ('replicated');
58 connection slave;
59 create trigger t1rbr before insert on t1 for each row set new.a=now(6);
60 set @@global.slave_run_triggers_for_rbr= yes;
61 binlog 'LQfqWg8BAAAA/AAAAAABAAABAAQAMTAuMy42LU1hcmlhREItZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAtB+paEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEwQADQgICAoKCgFlBcaR';
62 binlog '0gKWSRMBAAAAMQAAAHQDAAAAAB8AAAAAAAEABHRlc3QAAnQxAAIPEQMUAAYBQFUzwA==0gKWSRcBAAAAMAAAAKQDAAAAAB8AAAAAAAEAAv/8BmJpbmxvZ0mWAtIBivg3mwo+';
63 set @@global.slave_run_triggers_for_rbr= default;
64 select b, if(a > 20100101, 'READONLY', 'EDITABLE') as 'REPLICATION' from t1;
65 b REPLICATION
66 replicated EDITABLE
67 binlog READONLY
68 connection master;
69 drop table t1;
70 include/rpl_end.inc