Debian Codegraph @

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

raw
1 select @@global.explicit_defaults_for_timestamp into @save_global_explicit_defaults_for_timestamp;
2 select @@session.explicit_defaults_for_timestamp into @save_session_explicit_defaults_for_timestamp;
3 show global variables like 'explicit_defaults_for_timestamp';
4 Variable_name Value
5 explicit_defaults_for_timestamp ON
6 show session variables like 'explicit_defaults_for_timestamp';
7 Variable_name Value
8 explicit_defaults_for_timestamp ON
9 select * from performance_schema.global_variables where variable_name='explicit_defaults_for_timestamp';
10 VARIABLE_NAME VARIABLE_VALUE
11 explicit_defaults_for_timestamp ON
12 select * from performance_schema.session_variables where variable_name='explicit_defaults_for_timestamp';
13 VARIABLE_NAME VARIABLE_VALUE
14 explicit_defaults_for_timestamp ON
15 SET GLOBAL explicit_defaults_for_timestamp=TRUE;
16 SET SESSION explicit_defaults_for_timestamp=TRUE;
17 SET GLOBAL explicit_defaults_for_timestamp=@save_global_explicit_defaults_for_timestamp;
18 SET SESSION explicit_defaults_for_timestamp=@save_session_explicit_defaults_for_timestamp;
19 ** Creating new user without super privilege**
20 CREATE USER damn;
21 ** Connecting connn using username 'sameea' **
22 SET GLOBAL explicit_defaults_for_timestamp=TRUE;
23 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
24 DROP USER damn;
25 #
26 # WL#9687 : Change default for explicit_defaults_for_timestamp to ON
27 #
28 SET GLOBAL explicit_defaults_for_timestamp = 0;
29 Warnings:
30 Warning 1287 'explicit_defaults_for_timestamp' is deprecated and will be removed in a future release.
31 SET explicit_defaults_for_timestamp = 0;
32 Warnings:
33 Warning 1287 'explicit_defaults_for_timestamp' is deprecated and will be removed in a future release.
34 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';
35 Variable_name Value
36 explicit_defaults_for_timestamp OFF
37 SET GLOBAL explicit_defaults_for_timestamp = default;
38 SET explicit_defaults_for_timestamp = default;
39 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';
40 Variable_name Value
41 explicit_defaults_for_timestamp ON