Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.interactive_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 28800
5 SET @start_session_value = @@session.interactive_timeout;
6 SELECT @start_session_value;
7 @start_session_value
8 28800
9 '#--------------------FN_DYNVARS_052_01-------------------------#'
10 SET @@global.interactive_timeout = 100;
11 SET @@global.interactive_timeout = DEFAULT;
12 SELECT @@global.interactive_timeout;
13 @@global.interactive_timeout
14 28800
15 SET @@session.interactive_timeout = 200;
16 SET @@session.interactive_timeout = DEFAULT;
17 SELECT @@session.interactive_timeout;
18 @@session.interactive_timeout
19 28800
20 '#--------------------FN_DYNVARS_052_02-------------------------#'
21 SET @@global.interactive_timeout = DEFAULT;
22 SELECT @@global.interactive_timeout = 28800;
23 @@global.interactive_timeout = 28800
24 1
25 SET @@session.interactive_timeout = DEFAULT;
26 SELECT @@session.interactive_timeout = 28800;
27 @@session.interactive_timeout = 28800
28 1
29 '#--------------------FN_DYNVARS_052_03-------------------------#'
30 SET @@global.interactive_timeout = 1;
31 SELECT @@global.interactive_timeout;
32 @@global.interactive_timeout
33 1
34 SET @@global.interactive_timeout = 60020;
35 SELECT @@global.interactive_timeout;
36 @@global.interactive_timeout
37 60020
38 SET @@global.interactive_timeout = 65535;
39 SELECT @@global.interactive_timeout;
40 @@global.interactive_timeout
41 65535
42 SET @@global.interactive_timeout = 31536000;
43 SELECT @@global.interactive_timeout;
44 @@global.interactive_timeout
45 31536000
46 '#--------------------FN_DYNVARS_052_04-------------------------#'
47 SET @@session.interactive_timeout = 1;
48 SELECT @@session.interactive_timeout;
49 @@session.interactive_timeout
50 1
51 SET @@session.interactive_timeout = 50050;
52 SELECT @@session.interactive_timeout;
53 @@session.interactive_timeout
54 50050
55 SET @@session.interactive_timeout = 65535;
56 SELECT @@session.interactive_timeout;
57 @@session.interactive_timeout
58 65535
59 SET @@session.interactive_timeout = 31536000;
60 SELECT @@session.interactive_timeout;
61 @@session.interactive_timeout
62 31536000
63 '#------------------FN_DYNVARS_052_05-----------------------#'
64 SET @@global.interactive_timeout = 0;
65 Warnings:
66 Warning 1292 Truncated incorrect interactive_timeout value: '0'
67 SELECT @@global.interactive_timeout;
68 @@global.interactive_timeout
69 1
70 SET @@global.interactive_timeout = -1024;
71 Warnings:
72 Warning 1292 Truncated incorrect interactive_timeout value: '-1024'
73 SELECT @@global.interactive_timeout;
74 @@global.interactive_timeout
75 1
76 SET @@global.interactive_timeout = 31536001;
77 Warnings:
78 Warning 1292 Truncated incorrect interactive_timeout value: '31536001'
79 SELECT @@global.interactive_timeout;
80 @@global.interactive_timeout
81 31536000
82 SET @@global.interactive_timeout = 1000000000;
83 Warnings:
84 Warning 1292 Truncated incorrect interactive_timeout value: '1000000000'
85 SELECT @@global.interactive_timeout;
86 @@global.interactive_timeout
87 31536000
88 SET @@global.interactive_timeout = 65530.34;
89 ERROR 42000: Incorrect argument type to variable 'interactive_timeout'
90 SELECT @@global.interactive_timeout;
91 @@global.interactive_timeout
92 31536000
93 SET @@global.interactive_timeout = test;
94 ERROR 42000: Incorrect argument type to variable 'interactive_timeout'
95 SELECT @@global.interactive_timeout;
96 @@global.interactive_timeout
97 31536000
98 SET @@session.interactive_timeout = 0;
99 Warnings:
100 Warning 1292 Truncated incorrect interactive_timeout value: '0'
101 SELECT @@session.interactive_timeout;
102 @@session.interactive_timeout
103 1
104 SET @@session.interactive_timeout = -2;
105 Warnings:
106 Warning 1292 Truncated incorrect interactive_timeout value: '-2'
107 SELECT @@session.interactive_timeout;
108 @@session.interactive_timeout
109 1
110 SET @@session.interactive_timeout = 65530.34;
111 ERROR 42000: Incorrect argument type to variable 'interactive_timeout'
112 SELECT @@session.interactive_timeout;
113 @@session.interactive_timeout
114 1
115 SET @@session.interactive_timeout = 31536001;
116 Warnings:
117 Warning 1292 Truncated incorrect interactive_timeout value: '31536001'
118 SELECT @@session.interactive_timeout;
119 @@session.interactive_timeout
120 31536000
121 SET @@session.interactive_timeout = 100000000;
122 Warnings:
123 Warning 1292 Truncated incorrect interactive_timeout value: '100000000'
124 SELECT @@session.interactive_timeout;
125 @@session.interactive_timeout
126 31536000
127 SET @@session.interactive_timeout = test;
128 ERROR 42000: Incorrect argument type to variable 'interactive_timeout'
129 SELECT @@session.interactive_timeout;
130 @@session.interactive_timeout
131 31536000
132 '#------------------FN_DYNVARS_052_06-----------------------#'
133 SELECT @@global.interactive_timeout = VARIABLE_VALUE
134 FROM performance_schema.global_variables
135 WHERE VARIABLE_NAME='interactive_timeout';
136 @@global.interactive_timeout = VARIABLE_VALUE
137 1
138 '#------------------FN_DYNVARS_052_07-----------------------#'
139 SELECT @@session.interactive_timeout = VARIABLE_VALUE
140 FROM performance_schema.session_variables
141 WHERE VARIABLE_NAME='interactive_timeout';
142 @@session.interactive_timeout = VARIABLE_VALUE
143 1
144 '#------------------FN_DYNVARS_052_08-----------------------#'
145 SET @@global.interactive_timeout = TRUE;
146 SELECT @@global.interactive_timeout;
147 @@global.interactive_timeout
148 1
149 SET @@global.interactive_timeout = FALSE;
150 Warnings:
151 Warning 1292 Truncated incorrect interactive_timeout value: '0'
152 SELECT @@global.interactive_timeout;
153 @@global.interactive_timeout
154 1
155 '#---------------------FN_DYNVARS_052_09----------------------#'
156 SET @@global.interactive_timeout = 10;
157 SELECT @@interactive_timeout = @@global.interactive_timeout;
158 @@interactive_timeout = @@global.interactive_timeout
159 0
160 '#---------------------FN_DYNVARS_052_10----------------------#'
161 SET @@interactive_timeout = 100;
162 SELECT @@interactive_timeout = @@local.interactive_timeout;
163 @@interactive_timeout = @@local.interactive_timeout
164 1
165 SELECT @@local.interactive_timeout = @@session.interactive_timeout;
166 @@local.interactive_timeout = @@session.interactive_timeout
167 1
168 '#---------------------FN_DYNVARS_052_11----------------------#'
169 SET interactive_timeout = 1;
170 SELECT @@interactive_timeout;
171 @@interactive_timeout
172 1
173 SELECT local.interactive_timeout;
174 ERROR 42S02: Unknown table 'local' in field list
175 SELECT session.interactive_timeout;
176 ERROR 42S02: Unknown table 'session' in field list
177 SELECT interactive_timeout = @@session.interactive_timeout;
178 ERROR 42S22: Unknown column 'interactive_timeout' in 'field list'
179 SET @@global.interactive_timeout = @start_global_value;
180 SELECT @@global.interactive_timeout;
181 @@global.interactive_timeout
182 28800
183 SET @@session.interactive_timeout = @start_session_value;
184 SELECT @@session.interactive_timeout;
185 @@session.interactive_timeout
186 28800