Debian Codegraph @

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

raw
1 #
2 # Variable name : session_track_schema
3 # Scope : Global & Session
4 #
5 # Global - default
6 SELECT @@global.session_track_schema;
7 @@global.session_track_schema
8 1
9 # Session - default
10 SELECT @@session.session_track_schema;
11 @@session.session_track_schema
12 1
13
14 # via performance_schema.global_variables
15 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'track_current%';
16 VARIABLE_NAME VARIABLE_VALUE
17 # via performance_schema.session_variables
18 SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'track_current%';
19 VARIABLE_NAME VARIABLE_VALUE
20 SET @global_saved_tmp = @@global.session_track_schema;
21
22 # Altering global variable's value
23 SET @@global.session_track_schema = 0;
24 SELECT @@global.session_track_schema;
25 @@global.session_track_schema
26 0
27 SELECT @@session.session_track_schema;
28 @@session.session_track_schema
29 1
30 SET @@global.session_track_schema = TrUe;
31 SELECT @@global.session_track_schema;
32 @@global.session_track_schema
33 1
34 SELECT @@session.session_track_schema;
35 @@session.session_track_schema
36 1
37 SET @@global.session_track_schema = FaLsE;
38 SELECT @@global.session_track_schema;
39 @@global.session_track_schema
40 0
41 SELECT @@session.session_track_schema;
42 @@session.session_track_schema
43 1
44
45 # Altering session variable's value
46 SET @@session.session_track_schema = 0;
47 SELECT @@global.session_track_schema;
48 @@global.session_track_schema
49 0
50 SELECT @@session.session_track_schema;
51 @@session.session_track_schema
52 0
53
54 # Variables' values in a new session.
55 # Global - expect 0
56 SELECT @@global.session_track_schema;
57 @@global.session_track_schema
58 0
59
60 # Session - expect 0
61 SELECT @@session.session_track_schema;
62 @@session.session_track_schema
63 0
64
65 # Switching to the default connection.
66 SELECT @@global.session_track_schema;
67 @@global.session_track_schema
68 0
69 SELECT @@session.session_track_schema;
70 @@session.session_track_schema
71 0
72
73 # Test if DEFAULT is working as expected.
74 SET @@global.session_track_schema = DEFAULT;
75 SET @@session.session_track_schema = DEFAULT;
76
77 # Global - expect 1
78 SELECT @@global.session_track_schema;
79 @@global.session_track_schema
80 1
81 # Session - expect 1
82 SELECT @@session.session_track_schema;
83 @@session.session_track_schema
84 1
85
86 # Variables' values in a new session (con2).
87 SELECT @@global.session_track_schema;
88 @@global.session_track_schema
89 1
90 SELECT @@session.session_track_schema;
91 @@session.session_track_schema
92 1
93
94 # Altering session should not affect global.
95 SET @@session.session_track_schema = FALSE;
96 SELECT @@global.session_track_schema;
97 @@global.session_track_schema
98 1
99 SELECT @@session.session_track_schema;
100 @@session.session_track_schema
101 0
102
103 # Variables' values in a new session (con3).
104 # Altering global should not affect session.
105 SET @@global.session_track_schema = OFF;
106 SELECT @@global.session_track_schema;
107 @@global.session_track_schema
108 0
109 SELECT @@session.session_track_schema;
110 @@session.session_track_schema
111 1
112
113 # Switching to the default connection.
114 # Restoring the original values.
115 SET @@global.session_track_schema = @global_saved_tmp;
116 # End of tests.