Debian Codegraph @

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

raw
1 #
2 # Variable name : session_track_system_variables
3 # Scope : Global & Session
4 #
5 # Global - default
6 SELECT @@global.session_track_system_variables;
7 @@global.session_track_system_variables
8 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
9 # Session - default
10 SELECT @@session.session_track_system_variables;
11 @@session.session_track_system_variables
12 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
13
14 # via performance_schema.global_variables
15 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'session_track%' ORDER BY VARIABLE_NAME;
16 VARIABLE_NAME VARIABLE_VALUE
17 session_track_gtids OFF
18 session_track_schema ON
19 session_track_state_change OFF
20 session_track_system_variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
21 session_track_transaction_info OFF
22 # via performance_schema.session_variables
23 SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'session_track%' ORDER BY VARIABLE_NAME;
24 VARIABLE_NAME VARIABLE_VALUE
25 session_track_gtids OFF
26 session_track_schema ON
27 session_track_state_change OFF
28 session_track_system_variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
29 session_track_transaction_info OFF
30 SET @global_saved_tmp = @@global.session_track_system_variables;
31
32 # Altering global variable's value
33 SET @@global.session_track_system_variables='autocommit';
34 SELECT @@global.session_track_system_variables;
35 @@global.session_track_system_variables
36 autocommit
37 SELECT @@session.session_track_system_variables;
38 @@session.session_track_system_variables
39 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
40
41 # Altering session variable's value
42 SET @@session.session_track_system_variables='autocommit';
43 SELECT @@global.session_track_system_variables;
44 @@global.session_track_system_variables
45 autocommit
46 SELECT @@session.session_track_system_variables;
47 @@session.session_track_system_variables
48 autocommit
49
50 # Variables' values in a new session.
51 # Global - expect "autocommit"
52 SELECT @@global.session_track_system_variables;
53 @@global.session_track_system_variables
54 autocommit
55
56 # Session - expect "autocommit"
57 SELECT @@session.session_track_system_variables;
58 @@session.session_track_system_variables
59 autocommit
60
61 # Switching to the default connection.
62 SELECT @@global.session_track_system_variables;
63 @@global.session_track_system_variables
64 autocommit
65 SELECT @@session.session_track_system_variables;
66 @@session.session_track_system_variables
67 autocommit
68
69 # Test if DEFAULT is working as expected.
70 SET @@global.session_track_system_variables = DEFAULT;
71 SET @@session.session_track_system_variables = DEFAULT;
72
73 SELECT @@global.session_track_system_variables;
74 @@global.session_track_system_variables
75 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
76 SELECT @@session.session_track_system_variables;
77 @@session.session_track_system_variables
78 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
79
80 # Variables' values in a new session (con2).
81 SELECT @@global.session_track_system_variables;
82 @@global.session_track_system_variables
83 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
84 SELECT @@session.session_track_system_variables;
85 @@session.session_track_system_variables
86 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
87
88 # Altering session should not affect global.
89 SET @@session.session_track_system_variables = 'sql_mode';
90 SELECT @@global.session_track_system_variables;
91 @@global.session_track_system_variables
92 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
93 SELECT @@session.session_track_system_variables;
94 @@session.session_track_system_variables
95 sql_mode
96
97 # Variables' values in a new session (con3).
98 # Altering global should not affect session.
99 SET @@global.session_track_system_variables = 'sql_mode';
100 SELECT @@global.session_track_system_variables;
101 @@global.session_track_system_variables
102 sql_mode
103 SELECT @@session.session_track_system_variables;
104 @@session.session_track_system_variables
105 time_zone,autocommit,character_set_client,character_set_results,character_set_connection
106
107 # Switching to the default connection.
108 # Testing NULL
109 SET @@global.session_track_system_variables = NULL;
110 SET @@session.session_track_system_variables = NULL;
111 # Global - expect NULL
112 SELECT @@global.session_track_system_variables;
113 @@global.session_track_system_variables
114 NULL
115 # Session - expect NULL
116 SELECT @@session.session_track_system_variables;
117 @@session.session_track_system_variables
118 NULL
119 # testing with duplicate entries (must fail).
120 SET @@global.session_track_system_variables= "time_zone";
121 SET @@session.session_track_system_variables= "time_zone";
122 SET @@global.session_track_system_variables= "sql_mode,sql_mode";
123 ERROR HY000: Duplicate entry 'sql_mode'.
124 SET @@session.session_track_system_variables= "sql_mode,sql_mode";
125 ERROR HY000: Duplicate entry 'sql_mode'.
126 # Global - must remain unchanged, 'time_zone'
127 SELECT @@global.session_track_system_variables;
128 @@global.session_track_system_variables
129 time_zone
130 # Session - must remain unchanged, 'time_zone'
131 SELECT @@session.session_track_system_variables;
132 @@session.session_track_system_variables
133 time_zone
134
135 # Restoring the original values.
136 SET @@global.session_track_system_variables = @global_saved_tmp;
137 # End of tests.