Debian Codegraph @

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

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