Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.wait_timeout;
2 SET @start_session_value = @@session.wait_timeout;
3 '#--------------------FN_DYNVARS_005_01-------------------------#'
4 SET @@global.wait_timeout = 100;
5 SET @@global.wait_timeout = DEFAULT;
6 SELECT @@global.wait_timeout;
7 @@global.wait_timeout
8 28800
9 SET @@session.wait_timeout = 200;
10 SET @@session.wait_timeout = DEFAULT;
11 SELECT @@session.wait_timeout;
12 @@session.wait_timeout
13 28800
14 '#--------------------FN_DYNVARS_005_02-------------------------#'
15 SET @@global.wait_timeout = DEFAULT;
16 SELECT @@global.wait_timeout = @default_wait_timeout;
17 @@global.wait_timeout = @default_wait_timeout
18 1
19 SET @@session.wait_timeout = DEFAULT;
20 SELECT @@session.wait_timeout = @default_wait_timeout;
21 @@session.wait_timeout = @default_wait_timeout
22 1
23 '#--------------------FN_DYNVARS_005_03-------------------------#'
24 SET @@global.wait_timeout= 1;
25 SELECT @@global.wait_timeout;
26 @@global.wait_timeout
27 1
28 SET @@global.wait_timeout = 60020;
29 SELECT @@global.wait_timeout;
30 @@global.wait_timeout
31 60020
32 SET @@global.wait_timeout = 31536000;
33 SELECT @@global.wait_timeout = @max_wait_timeout;
34 @@global.wait_timeout = @max_wait_timeout
35 1
36 '#--------------------FN_DYNVARS_005_04-------------------------#'
37 SET @@session.wait_timeout =6000;
38 SELECT @@session.wait_timeout;
39 @@session.wait_timeout
40 6000
41 '#------------------FN_DYNVARS_005_05-----------------------#'
42 SET @@global.wait_timeout = 0;
43 Warnings:
44 Warning 1292 Truncated incorrect wait_timeout value: '0'
45 SELECT @@global.wait_timeout;
46 @@global.wait_timeout
47 1
48 SET @@global.wait_timeout = -1024;
49 Warnings:
50 Warning 1292 Truncated incorrect wait_timeout value: '-1024'
51 SELECT @@global.wait_timeout;
52 @@global.wait_timeout
53 1
54 SET @@global.wait_timeout = 123456789031;
55 Warnings:
56 Warning 1292 Truncated incorrect wait_timeout value: '123456789031'
57 SELECT @@global.wait_timeout;
58 @@global.wait_timeout
59 31536000
60 SET @@global.wait_timeout = 31536003;
61 Warnings:
62 Warning 1292 Truncated incorrect wait_timeout value: '31536003'
63 SELECT @@global.wait_timeout;
64 @@global.wait_timeout
65 31536000
66 SET @@global.wait_timeout = ' ';
67 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
68 SELECT @@global.wait_timeout;
69 @@global.wait_timeout
70 31536000
71 SET @@global.wait_timeout = ON;
72 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
73 SET @@global.wait_timeout = OFF;
74 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
75 SET @@global.wait_timeout = True;
76 SELECT @@global.wait_timeout;
77 @@global.wait_timeout
78 1
79 SET @@global.wait_timeout = False;
80 Warnings:
81 Warning 1292 Truncated incorrect wait_timeout value: '0'
82 SELECT @@global.wait_timeout;
83 @@global.wait_timeout
84 1
85 SET @@global.wait_timeout = 65530.34;
86 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
87 SELECT @@global.wait_timeout;
88 @@global.wait_timeout
89 1
90 SET @@global.wait_timeout ="Test";
91 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
92 SET @@session.wait_timeout = ON;
93 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
94 SET @@session.wait_timeout = OFF;
95 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
96 SET @@session.wait_timeout = True;
97 SELECT @@session.wait_timeout;
98 @@session.wait_timeout
99 1
100 SET @@session.wait_timeout = False;
101 Warnings:
102 Warning 1292 Truncated incorrect wait_timeout value: '0'
103 SELECT @@session.wait_timeout;
104 @@session.wait_timeout
105 1
106 SET @@session.wait_timeout = "Test";
107 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
108 SET @@session.wait_timeout = 65530.34;
109 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
110 SELECT @@session.wait_timeout;
111 @@session.wait_timeout
112 1
113 SET @@session.wait_timeout = 'test';
114 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
115 SET @@session.wait_timeout = 0;
116 Warnings:
117 Warning 1292 Truncated incorrect wait_timeout value: '0'
118 SELECT @@session.wait_timeout;
119 @@session.wait_timeout
120 1
121 SELECT @@session.wait_timeout = @max_wait_timeout;
122 @@session.wait_timeout = @max_wait_timeout
123 0
124 SELECT @@session.wait_timeout;
125 @@session.wait_timeout
126 1
127 SET @@session.wait_timeout = ' ';
128 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
129 SELECT @@session.wait_timeout;
130 @@session.wait_timeout
131 1
132 '#------------------FN_DYNVARS_005_06-----------------------#'
133 SELECT @@global.wait_timeout = VARIABLE_VALUE
134 FROM performance_schema.global_variables
135 WHERE VARIABLE_NAME='wait_timeout';
136 @@global.wait_timeout = VARIABLE_VALUE
137 1
138 '#------------------FN_DYNVARS_005_07-----------------------#'
139 SELECT @@session.wait_timeout = VARIABLE_VALUE
140 FROM performance_schema.session_variables
141 WHERE VARIABLE_NAME='wait_timeout';
142 @@session.wait_timeout = VARIABLE_VALUE
143 1
144 '#---------------------FN_DYNVARS_001_09----------------------#'
145 SET @@global.wait_timeout = 30000;
146 SET @@global.wait_timeout = 40000;
147 SELECT @@wait_timeout = @@global.wait_timeout;
148 @@wait_timeout = @@global.wait_timeout
149 0
150 '#---------------------FN_DYNVARS_001_10----------------------#'
151 SET @@wait_timeout = 100;
152 SELECT @@wait_timeout = @@local.wait_timeout;
153 @@wait_timeout = @@local.wait_timeout
154 1
155 SELECT @@local.wait_timeout = @@session.wait_timeout;
156 @@local.wait_timeout = @@session.wait_timeout
157 1
158 '#---------------------FN_DYNVARS_001_11----------------------#'
159 SET wait_timeout = 1027;
160 SELECT @@wait_timeout;
161 @@wait_timeout
162 1027
163 SELECT local.wait_timeout;
164 ERROR 42S02: Unknown table 'local' in field list
165 SELECT session.wait_timeout;
166 ERROR 42S02: Unknown table 'session' in field list
167 SELECT wait_timeout = @@session.wait_timeout;
168 ERROR 42S22: Unknown column 'wait_timeout' in 'field list'
169 SET @@global.wait_timeout = @start_global_value;
170 SET @@session.wait_timeout = @start_session_value;