Debian Codegraph @

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

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