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 @@session.net_write_timeout = 0;
85 Warnings:
86 Warning 1292 Truncated incorrect net_write_timeout value: '0'
87 SELECT @@session.net_write_timeout;
88 @@session.net_write_timeout
89 1
90 SET @@session.net_write_timeout = -2;
91 Warnings:
92 Warning 1292 Truncated incorrect net_write_timeout value: '-2'
93 SELECT @@session.net_write_timeout;
94 @@session.net_write_timeout
95 1
96 SET @@session.net_write_timeout = 65530.34;
97 ERROR 42000: Incorrect argument type to variable 'net_write_timeout'
98 SET @@session.net_write_timeout = 6555015425;
99 Warnings:
100 Warning 1292 Truncated incorrect net_write_timeout value: '6555015425'
101 SELECT @@session.net_write_timeout;
102 @@session.net_write_timeout
103 31536000
104 SET @@session.net_write_timeout = test;
105 ERROR 42000: Incorrect argument type to variable 'net_write_timeout'
106 SELECT @@session.net_write_timeout;
107 @@session.net_write_timeout
108 31536000
109 '#------------------FN_DYNVARS_112_06-----------------------#'
110 SELECT @@global.net_write_timeout = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='net_write_timeout';
111 @@global.net_write_timeout = VARIABLE_VALUE
112 1
113 '#------------------FN_DYNVARS_112_07-----------------------#'
114 SELECT @@session.net_write_timeout = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='net_write_timeout';
115 @@session.net_write_timeout = VARIABLE_VALUE
116 1
117 '#------------------FN_DYNVARS_112_08-----------------------#'
118 SET @@global.net_write_timeout = TRUE;
119 SELECT @@global.net_write_timeout;
120 @@global.net_write_timeout
121 1
122 SET @@global.net_write_timeout = FALSE;
123 Warnings:
124 Warning 1292 Truncated incorrect net_write_timeout value: '0'
125 SELECT @@global.net_write_timeout;
126 @@global.net_write_timeout
127 1
128 '#---------------------FN_DYNVARS_112_09----------------------#'
129 SET @@global.net_write_timeout = 10;
130 SELECT @@net_write_timeout = @@global.net_write_timeout;
131 @@net_write_timeout = @@global.net_write_timeout
132 0
133 '#---------------------FN_DYNVARS_112_10----------------------#'
134 SET @@net_write_timeout = 100;
135 SELECT @@net_write_timeout = @@local.net_write_timeout;
136 @@net_write_timeout = @@local.net_write_timeout
137 1
138 SELECT @@local.net_write_timeout = @@session.net_write_timeout;
139 @@local.net_write_timeout = @@session.net_write_timeout
140 1
141 '#---------------------FN_DYNVARS_112_11----------------------#'
142 SET net_write_timeout = 1;
143 SELECT @@net_write_timeout;
144 @@net_write_timeout
145 1
146 SELECT local.net_write_timeout;
147 ERROR 42S02: Unknown table 'local' in SELECT
148 SELECT session.net_write_timeout;
149 ERROR 42S02: Unknown table 'session' in SELECT
150 SELECT net_write_timeout = @@session.net_write_timeout;
151 ERROR 42S22: Unknown column 'net_write_timeout' in 'SELECT'
152 SET @@global.net_write_timeout = @start_global_value;
153 SELECT @@global.net_write_timeout;
154 @@global.net_write_timeout
155 60
156 SET @@session.net_write_timeout = @start_session_value;
157 SELECT @@session.net_write_timeout;
158 @@session.net_write_timeout
159 60