Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 select @@secure_timestamp;
5 @@secure_timestamp
6 NO
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 select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'non-privileged';
42 non-privileged
43 EDITABLE
44 disconnect con2;
45 connection slave;
46 drop user [email protected];
47 set timestamp=default;
48 connection master;
49 set time_zone='+00:00';
50 set timestamp=1234567890.101112;
51 select @@timestamp, now(6);
52 @@timestamp now(6)
53 1234567890.101112 2009-02-13 23:31:30.101112
54 create table t1 (b varchar(20), a timestamp(6) default current_timestamp(6)) charset=latin1;
55 insert t1 (b) values ('replicated');
56 connection slave;
57 create trigger t1rbr before insert on t1 for each row set new.a=now(6);
58 set @@global.slave_run_triggers_for_rbr= yes;
59 binlog 'LQfqWg8BAAAA/AAAAAABAAABAAQAMTAuMy42LU1hcmlhREItZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAtB+paEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEwQADQgICAoKCgFlBcaR';
60 binlog '0gKWSRMBAAAAMQAAAHQDAAAAAB8AAAAAAAEABHRlc3QAAnQxAAIPEQMUAAYBQFUzwA==0gKWSRcBAAAAMAAAAKQDAAAAAB8AAAAAAAEAAv/8BmJpbmxvZ0mWAtIBivg3mwo+';
61 set @@global.slave_run_triggers_for_rbr= default;
62 select b, if(a > 20100101, 'READONLY', 'EDITABLE') as 'REPLICATION' from t1;
63 b REPLICATION
64 replicated EDITABLE
65 binlog EDITABLE
66 connection master;
67 drop table t1;
68 include/rpl_end.inc