Debian Codegraph @

mysql-test/suite/sys_vars/t/log_timestamps_basic.test

raw
1 SET @old_log_timestamps = @@global.log_timestamps;
2
3 # log_timestamps -- values UTC|SYSTEM
4 SET GLOBAL log_timestamps=UTC;
5 SELECT @@global.log_timestamps;
6 SET GLOBAL log_timestamps=SYSTEM;
7 SELECT @@global.log_timestamps;
8
9 # sess var
10 --error ER_GLOBAL_VARIABLE
11 SET SESSION log_timestamps=UTC;
12
13 # wrong value
14 --error ER_WRONG_VALUE_FOR_VAR
15 SET GLOBAL log_timestamps=ON;
16 --error ER_WRONG_VALUE_FOR_VAR
17 SET GLOBAL log_timestamps=2;
18
19
20 # log_timestamps -- default UTC
21 SET GLOBAL log_timestamps=DEFAULT;
22 SELECT @@global.log_timestamps;
23
24 SET GLOBAL log_timestamps = @old_log_timestamps;