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