Debian Codegraph @

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

raw
1 SET @old_log_timestamps = @@global.log_timestamps;
2 SET GLOBAL log_timestamps=UTC;
3 SELECT @@global.log_timestamps;
4 @@global.log_timestamps
5 UTC
6 SET GLOBAL log_timestamps=SYSTEM;
7 SELECT @@global.log_timestamps;
8 @@global.log_timestamps
9 SYSTEM
10 SET SESSION log_timestamps=UTC;
11 ERROR HY000: Variable 'log_timestamps' is a GLOBAL variable and should be set with SET GLOBAL
12 SET GLOBAL log_timestamps=ON;
13 ERROR 42000: Variable 'log_timestamps' can't be set to the value of 'ON'
14 SET GLOBAL log_timestamps=2;
15 ERROR 42000: Variable 'log_timestamps' can't be set to the value of '2'
16 SET GLOBAL log_timestamps=DEFAULT;
17 SELECT @@global.log_timestamps;
18 @@global.log_timestamps
19 UTC
20 SET GLOBAL log_timestamps = @old_log_timestamps;