Debian Codegraph @

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

raw
1 #
2 # Show the session value;
3 #
4 SELECT @@session.show_old_temporals;
5 SHOW SESSION VARIABLES LIKE 'show_old_temporals';
6 --disable_warnings
7 SELECT * FROM performance_schema.session_variables WHERE variable_name='show_old_temporals';
8 --enable_warnings
9
10 --echo #Also can be set as a global variable.
11 SELECT @@global.show_old_temporals;
12 SHOW GLOBAL VARIABLES LIKE 'show_old_temporals';
13 --disable_warnings
14 SELECT * FROM performance_schema.global_variables WHERE variable_name='show_old_temporals';
15 --enable_warnings
16
17 --echo #Test setting the variable to various values.
18 --echo #Boolean values.
19 SET SESSION show_old_temporals= ON;
20 SELECT @@session.show_old_temporals;
21
22 SET SESSION show_old_temporals= OFF;
23 SELECT @@session.show_old_temporals;
24
25 SET SESSION show_old_temporals= 1;
26 SELECT @@session.show_old_temporals;
27
28 SET SESSION show_old_temporals= 0;
29 SELECT @@session.show_old_temporals;
30
31 --echo #Test for DEFAULT value.
32 SET SESSION show_old_temporals= DEFAULT;
33 SELECT @@session.show_old_temporals;
34
35 --echo #Test for invalid value.
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET SESSION show_old_temporals= 2;
38
39 --echo #Test for setting the session variable
40 --echo #using different syntax.
41 SET show_old_temporals= 1;
42
43 --echo #Fetches the current session value for the variable.
44 SELECT @@show_old_temporals;
45
46 --echo #cleanup
47 SET SESSION show_old_temporals= DEFAULT;
48
49 --echo #Test setting the global value of the variable.
50 --echo #Boolean values.
51 SET GLOBAL show_old_temporals= ON;
52 SELECT @@global.show_old_temporals;
53
54 SET GLOBAL show_old_temporals= OFF;
55 SELECT @@global.show_old_temporals;
56
57 SET GLOBAL show_old_temporals= 1;
58 SELECT @@global.show_old_temporals;
59
60 SET GLOBAL show_old_temporals= 0;
61 SELECT @@session.show_old_temporals;
62
63 --echo #Test for DEFAULT value.
64 SET GLOBAL show_old_temporals= DEFAULT;
65 SELECT @@global.show_old_temporals;
66
67 --echo #Test for invalid value.
68 --error ER_WRONG_VALUE_FOR_VAR
69 SET GLOBAL show_old_temporals= 2;
70
71 ######################################################################################
72 # Check if changing session variable throws error without sufficient privileges #
73 ######################################################################################
74 CREATE USER foo, bar;
75 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
76 --let $conn_name = foo_connection
77 --connect($conn_name, localhost, foo,,,)
78 SELECT @@session.show_old_temporals;
79 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
80 SET @@session.show_old_temporals = 0;
81 --connection default
82 disconnect $conn_name;
83 --let $conn_name = bar_connection
84 --connect($conn_name, localhost, bar,,,)
85 SELECT @@session.show_old_temporals;
86 SET @@session.show_old_temporals = 0;
87 SELECT @@session.show_old_temporals;
88 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
89 SET @@global.show_old_temporals = 0;
90 --connection default
91 disconnect $conn_name;
92 DROP USER foo, bar;