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