Debian Codegraph @

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

raw
1 #
2 # show the global and session values;
3 #
4
5 select @@global.explicit_defaults_for_timestamp into @save_global_explicit_defaults_for_timestamp;
6 select @@session.explicit_defaults_for_timestamp into @save_session_explicit_defaults_for_timestamp;
7 show global variables like 'explicit_defaults_for_timestamp';
8 show session variables like 'explicit_defaults_for_timestamp';
9 --disable_warnings
10 select * from performance_schema.global_variables where variable_name='explicit_defaults_for_timestamp';
11 select * from performance_schema.session_variables where variable_name='explicit_defaults_for_timestamp';
12 --enable_warnings
13
14 #
15 # show that a SUPER privileged can write to the variables
16 #
17 SET GLOBAL explicit_defaults_for_timestamp=TRUE;
18 SET SESSION explicit_defaults_for_timestamp=TRUE;
19 SET GLOBAL explicit_defaults_for_timestamp=@save_global_explicit_defaults_for_timestamp;
20 SET SESSION explicit_defaults_for_timestamp=@save_session_explicit_defaults_for_timestamp;
21 #
22 # show that it's read-only to a NOT super privileged
23 #
24 --echo ** Creating new user without super privilege**
25 CREATE USER damn;
26 --echo ** Connecting connn using username 'sameea' **
27 connect (conn_damn,localhost,damn,,);
28
29 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
30 SET GLOBAL explicit_defaults_for_timestamp=TRUE;
31
32 --connection default
33 DROP USER damn;
34
35 --echo #
36 --echo # WL#9687 : Change default for explicit_defaults_for_timestamp to ON
37 --echo #
38
39 SET GLOBAL explicit_defaults_for_timestamp = 0;
40 SET explicit_defaults_for_timestamp = 0;
41 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';
42 SET GLOBAL explicit_defaults_for_timestamp = default;
43 SET explicit_defaults_for_timestamp = default;
44 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';