Debian Codegraph @

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

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