Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.net_buffer_length;
2 SET @@global.net_buffer_length = DEFAULT;
3 '#--------------------FN_DYNVARS_109_01-------------------------#'
4 SET @@global.net_buffer_length = 10000;
5 Warnings:
6 Warning 1292 Truncated incorrect net_buffer_length value: '10000'
7 SET @@global.net_buffer_length = DEFAULT;
8 SELECT @@global.net_buffer_length;
9 @@global.net_buffer_length
10 16384
11 SET @@session.net_buffer_length = 20000;
12 ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
13 SET @@session.net_buffer_length = DEFAULT;
14 ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
15 SELECT @@session.net_buffer_length;
16 @@session.net_buffer_length
17 16384
18 '#--------------------FN_DYNVARS_109_02-------------------------#'
19 SET @@global.net_buffer_length = DEFAULT;
20 SELECT @@global.net_buffer_length = 16384;
21 @@global.net_buffer_length = 16384
22 1
23 '#--------------------FN_DYNVARS_109_03-------------------------#'
24 SET @@global.net_buffer_length = 1024;
25 SELECT @@global.net_buffer_length;
26 @@global.net_buffer_length
27 1024
28 SET @@global.net_buffer_length = 1025;
29 Warnings:
30 Warning 1292 Truncated incorrect net_buffer_length value: '1025'
31 SELECT @@global.net_buffer_length;
32 @@global.net_buffer_length
33 1024
34 SET @@global.net_buffer_length = 1048576;
35 SELECT @@global.net_buffer_length;
36 @@global.net_buffer_length
37 1048576
38 SET @@global.net_buffer_length = 1048575;
39 Warnings:
40 Warning 1292 Truncated incorrect net_buffer_length value: '1048575'
41 SELECT @@global.net_buffer_length;
42 @@global.net_buffer_length
43 1047552
44 SET @@global.net_buffer_length = 65535;
45 Warnings:
46 Warning 1292 Truncated incorrect net_buffer_length value: '65535'
47 SELECT @@global.net_buffer_length;
48 @@global.net_buffer_length
49 64512
50 '#--------------------FN_DYNVARS_109_04-------------------------#'
51 '#------------------FN_DYNVARS_109_05-----------------------#'
52 SET @@global.net_buffer_length = 0;
53 Warnings:
54 Warning 1292 Truncated incorrect net_buffer_length value: '0'
55 SELECT @@global.net_buffer_length;
56 @@global.net_buffer_length
57 1024
58 SET @@global.net_buffer_length = -1024;
59 Warnings:
60 Warning 1292 Truncated incorrect net_buffer_length value: '-1024'
61 SELECT @@global.net_buffer_length;
62 @@global.net_buffer_length
63 1024
64 SET @@global.net_buffer_length = 1023;
65 Warnings:
66 Warning 1292 Truncated incorrect net_buffer_length value: '1023'
67 SELECT @@global.net_buffer_length;
68 @@global.net_buffer_length
69 1024
70 SET @@global.net_buffer_length = 1048577;
71 Warnings:
72 Warning 1292 Truncated incorrect net_buffer_length value: '1048577'
73 SELECT @@global.net_buffer_length;
74 @@global.net_buffer_length
75 1048576
76 SET @@global.net_buffer_length = 104857633;
77 Warnings:
78 Warning 1292 Truncated incorrect net_buffer_length value: '104857633'
79 SELECT @@global.net_buffer_length;
80 @@global.net_buffer_length
81 1048576
82 SET @@global.net_buffer_length = 65530.34;
83 ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
84 SELECT @@global.net_buffer_length;
85 @@global.net_buffer_length
86 1048576
87 SET @@global.net_buffer_length = test;
88 ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
89 SELECT @@global.net_buffer_length;
90 @@global.net_buffer_length
91 1048576
92 SET @@global.net_buffer_length = ' ';
93 ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
94 SELECT @@global.net_buffer_length;
95 @@global.net_buffer_length
96 1048576
97 SET @@session.net_buffer_length = test;
98 ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
99 SELECT @@session.net_buffer_length;
100 @@session.net_buffer_length
101 16384
102 '#------------------FN_DYNVARS_109_06-----------------------#'
103 SELECT @@global.net_buffer_length = VARIABLE_VALUE
104 FROM performance_schema.global_variables
105 WHERE VARIABLE_NAME='net_buffer_length';
106 @@global.net_buffer_length = VARIABLE_VALUE
107 1
108 '#------------------FN_DYNVARS_109_07-----------------------#'
109 SELECT @@session.net_buffer_length = VARIABLE_VALUE
110 FROM performance_schema.session_variables
111 WHERE VARIABLE_NAME='net_buffer_length';
112 @@session.net_buffer_length = VARIABLE_VALUE
113 1
114 '#------------------FN_DYNVARS_109_08-----------------------#'
115 SET @@global.net_buffer_length = TRUE;
116 Warnings:
117 Warning 1292 Truncated incorrect net_buffer_length value: '1'
118 SELECT @@global.net_buffer_length;
119 @@global.net_buffer_length
120 1024
121 SET @@global.net_buffer_length = FALSE;
122 Warnings:
123 Warning 1292 Truncated incorrect net_buffer_length value: '0'
124 SELECT @@global.net_buffer_length;
125 @@global.net_buffer_length
126 1024
127 '#---------------------FN_DYNVARS_109_09----------------------#'
128 SET @@global.net_buffer_length = 2048;
129 SELECT @@net_buffer_length = @@global.net_buffer_length;
130 @@net_buffer_length = @@global.net_buffer_length
131 0
132 '#---------------------FN_DYNVARS_109_10----------------------#'
133 '#---------------------FN_DYNVARS_109_11----------------------#'
134 SELECT @@net_buffer_length;
135 @@net_buffer_length
136 16384
137 SELECT local.net_buffer_length;
138 ERROR 42S02: Unknown table 'local' in field list
139 SELECT session.net_buffer_length;
140 ERROR 42S02: Unknown table 'session' in field list
141 SELECT net_buffer_length = @@session.net_buffer_length;
142 ERROR 42S22: Unknown column 'net_buffer_length' in 'field list'
143 SET @@global.net_buffer_length = @start_global_value;