Debian Codegraph @

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

raw
1
2 --echo #
3 --echo # Variable name : session_track_state_change
4 --echo # Scope : Global & Session
5 --echo #
6
7 --echo # Global - default
8 SELECT @@global.session_track_state_change;
9 --echo # Session - default
10 SELECT @@session.session_track_state_change;
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_state_change%';
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_state_change%';
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_state_change;
25 --echo
26
27 --echo # Altering global variable's value
28 SET @@global.session_track_state_change = 0;
29 SELECT @@global.session_track_state_change;
30 SELECT @@session.session_track_state_change;
31
32 SET @@global.session_track_state_change = TrUe;
33 SELECT @@global.session_track_state_change;
34 SELECT @@session.session_track_state_change;
35
36 SET @@global.session_track_state_change = FaLsE;
37 SELECT @@global.session_track_state_change;
38 SELECT @@session.session_track_state_change;
39 --echo
40
41 --echo # Altering session variable's value
42 SET @@session.session_track_state_change = 0;
43 SELECT @@global.session_track_state_change;
44 SELECT @@session.session_track_state_change;
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_state_change;
52 --echo
53 --echo # Session - expect 0
54 SELECT @@session.session_track_state_change;
55 --echo
56
57 --echo # Switching to the default connection.
58 connection default;
59
60 SELECT @@global.session_track_state_change;
61 SELECT @@session.session_track_state_change;
62 --echo
63
64 --echo # Test if DEFAULT is working as expected.
65 SET @@global.session_track_state_change = DEFAULT;
66 SET @@session.session_track_state_change = DEFAULT;
67 --echo
68
69 --echo # Global - expect 0
70 SELECT @@global.session_track_state_change;
71 --echo # Session - expect 0
72 SELECT @@session.session_track_state_change;
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_state_change;
79 SELECT @@session.session_track_state_change;
80 --echo
81
82 --echo # Altering session should not affect global.
83 SET @@session.session_track_state_change = FALSE;
84 SELECT @@global.session_track_state_change;
85 SELECT @@session.session_track_state_change;
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_state_change = OFF;
93 SELECT @@global.session_track_state_change;
94 SELECT @@session.session_track_state_change;
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_state_change = @global_saved_tmp;
102
103 --echo # End of tests.
104