Debian Codegraph @

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

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