1SET @start_global_value = @@global.net_buffer_length;
2SET @@global.net_buffer_length = DEFAULT;
3'#--------------------FN_DYNVARS_109_01-------------------------#'
4SET @@global.net_buffer_length = 10000;
5Warnings:
6Warning	1292	Truncated incorrect net_buffer_length value: '10000'
7SET @@global.net_buffer_length = DEFAULT;
8SELECT @@global.net_buffer_length;
9@@global.net_buffer_length
1016384
11SET @@session.net_buffer_length = 20000;
12ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
13SET @@session.net_buffer_length = DEFAULT;
14ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
15SELECT @@session.net_buffer_length;
16@@session.net_buffer_length
1716384
18'#--------------------FN_DYNVARS_109_02-------------------------#'
19SET @@global.net_buffer_length = DEFAULT;
20SELECT @@global.net_buffer_length = 16384;
21@@global.net_buffer_length = 16384
221
23'#--------------------FN_DYNVARS_109_03-------------------------#'
24SET @@global.net_buffer_length = 1024;
25SELECT @@global.net_buffer_length;
26@@global.net_buffer_length
271024
28SET @@global.net_buffer_length = 1025;
29Warnings:
30Warning	1292	Truncated incorrect net_buffer_length value: '1025'
31SELECT @@global.net_buffer_length;
32@@global.net_buffer_length
331024
34SET @@global.net_buffer_length = 1048576;
35SELECT @@global.net_buffer_length;
36@@global.net_buffer_length
371048576
38SET @@global.net_buffer_length = 1048575;
39Warnings:
40Warning	1292	Truncated incorrect net_buffer_length value: '1048575'
41SELECT @@global.net_buffer_length;
42@@global.net_buffer_length
431047552
44SET @@global.net_buffer_length = 65535;
45Warnings:
46Warning	1292	Truncated incorrect net_buffer_length value: '65535'
47SELECT @@global.net_buffer_length;
48@@global.net_buffer_length
4964512
50'#--------------------FN_DYNVARS_109_04-------------------------#'
51'#------------------FN_DYNVARS_109_05-----------------------#'
52SET @@global.net_buffer_length = 0;
53Warnings:
54Warning	1292	Truncated incorrect net_buffer_length value: '0'
55SELECT @@global.net_buffer_length;
56@@global.net_buffer_length
571024
58SET @@global.net_buffer_length = -1024;
59Warnings:
60Warning	1292	Truncated incorrect net_buffer_length value: '-1024'
61SELECT @@global.net_buffer_length;
62@@global.net_buffer_length
631024
64SET @@global.net_buffer_length = 1023;
65Warnings:
66Warning	1292	Truncated incorrect net_buffer_length value: '1023'
67SELECT @@global.net_buffer_length;
68@@global.net_buffer_length
691024
70SET @@global.net_buffer_length = 1048577;
71Warnings:
72Warning	1292	Truncated incorrect net_buffer_length value: '1048577'
73SELECT @@global.net_buffer_length;
74@@global.net_buffer_length
751048576
76SET @@global.net_buffer_length = 104857633;
77Warnings:
78Warning	1292	Truncated incorrect net_buffer_length value: '104857633'
79SELECT @@global.net_buffer_length;
80@@global.net_buffer_length
811048576
82SET @@global.net_buffer_length = 65530.34;
83ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
84SELECT @@global.net_buffer_length;
85@@global.net_buffer_length
861048576
87SET @@global.net_buffer_length = test;
88ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
89SELECT @@global.net_buffer_length;
90@@global.net_buffer_length
911048576
92SET @@global.net_buffer_length = ' ';
93ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
94SELECT @@global.net_buffer_length;
95@@global.net_buffer_length
961048576
97SET @@session.net_buffer_length = test;
98ERROR 42000: Incorrect argument type to variable 'net_buffer_length'
99SELECT @@session.net_buffer_length;
100@@session.net_buffer_length
10116384
102'#------------------FN_DYNVARS_109_06-----------------------#'
103SELECT @@global.net_buffer_length = VARIABLE_VALUE
104FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
105WHERE VARIABLE_NAME='net_buffer_length';
106@@global.net_buffer_length = VARIABLE_VALUE
1071
108'#------------------FN_DYNVARS_109_07-----------------------#'
109SELECT @@session.net_buffer_length = VARIABLE_VALUE
110FROM INFORMATION_SCHEMA.SESSION_VARIABLES
111WHERE VARIABLE_NAME='net_buffer_length';
112@@session.net_buffer_length = VARIABLE_VALUE
1131
114'#------------------FN_DYNVARS_109_08-----------------------#'
115SET @@global.net_buffer_length = TRUE;
116Warnings:
117Warning	1292	Truncated incorrect net_buffer_length value: '1'
118SELECT @@global.net_buffer_length;
119@@global.net_buffer_length
1201024
121SET @@global.net_buffer_length = FALSE;
122Warnings:
123Warning	1292	Truncated incorrect net_buffer_length value: '0'
124SELECT @@global.net_buffer_length;
125@@global.net_buffer_length
1261024
127'#---------------------FN_DYNVARS_109_09----------------------#'
128SET @@global.net_buffer_length = 2048;
129SELECT @@net_buffer_length = @@global.net_buffer_length;
130@@net_buffer_length = @@global.net_buffer_length
1310
132'#---------------------FN_DYNVARS_109_10----------------------#'
133'#---------------------FN_DYNVARS_109_11----------------------#'
134SELECT @@net_buffer_length;
135@@net_buffer_length
13616384
137SELECT local.net_buffer_length;
138ERROR 42S02: Unknown table 'local' in field list
139SELECT session.net_buffer_length;
140ERROR 42S02: Unknown table 'session' in field list
141SELECT net_buffer_length = @@session.net_buffer_length;
142ERROR 42S22: Unknown column 'net_buffer_length' in 'field list'
143SET @@global.net_buffer_length = @start_global_value;
144