Debian Codegraph @

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

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