1SET @start_global_value = @@global.sort_buffer_size;
2SET @start_session_value = @@session.sort_buffer_size;
3'#--------------------FN_DYNVARS_151_01-------------------------#'
4SET @@global.sort_buffer_size = 1000;
5SET @@global.sort_buffer_size = DEFAULT;
6SELECT @@global.sort_buffer_size;
7@@global.sort_buffer_size
8262144
9SET @@session.sort_buffer_size = 2000;
10SET @@session.sort_buffer_size = DEFAULT;
11SELECT @@session.sort_buffer_size;
12@@session.sort_buffer_size
13262144
14'#--------------------FN_DYNVARS_151_02-------------------------#'
15SET @@global.sort_buffer_size = DEFAULT;
16SELECT @@global.sort_buffer_size;
17@@global.sort_buffer_size
18262144
19SET @@session.sort_buffer_size = DEFAULT;
20SELECT @@session.sort_buffer_size;
21@@session.sort_buffer_size
22262144
23'#--------------------FN_DYNVARS_151_03-------------------------#'
24SET @@global.sort_buffer_size = 32776;
25SELECT @@global.sort_buffer_size;
26@@global.sort_buffer_size
2732776
28SET @@global.sort_buffer_size = 32777;
29SELECT @@global.sort_buffer_size;
30@@global.sort_buffer_size
3132777
32SET @@global.sort_buffer_size = 4294967295;
33SELECT @@global.sort_buffer_size;
34@@global.sort_buffer_size
354294967295
36SET @@global.sort_buffer_size = 4294967294;
37SELECT @@global.sort_buffer_size;
38@@global.sort_buffer_size
394294967294
40'#--------------------FN_DYNVARS_151_04-------------------------#'
41SET @@session.sort_buffer_size = 32776;
42SELECT @@session.sort_buffer_size;
43@@session.sort_buffer_size
4432776
45SET @@session.sort_buffer_size = 32777;
46SELECT @@session.sort_buffer_size;
47@@session.sort_buffer_size
4832777
49SET @@session.sort_buffer_size = 4294967295;
50SELECT @@session.sort_buffer_size;
51@@session.sort_buffer_size
524294967295
53SET @@session.sort_buffer_size = 4294967294;
54SELECT @@session.sort_buffer_size;
55@@session.sort_buffer_size
564294967294
57'#------------------FN_DYNVARS_151_05-----------------------#'
58SET @@global.sort_buffer_size = 32775;
59SELECT @@global.sort_buffer_size;
60@@global.sort_buffer_size
6132775
62SET @@global.sort_buffer_size = -1024;
63SELECT @@global.sort_buffer_size;
64@@global.sort_buffer_size
6532768
66SET @@global.sort_buffer_size = 4294967296;
67SELECT @@global.sort_buffer_size;
68@@global.sort_buffer_size
694294967295
70SET @@global.sort_buffer_size = 65530.34;
71ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
72SELECT @@global.sort_buffer_size;
73@@global.sort_buffer_size
744294967295
75SET @@global.sort_buffer_size = test;
76ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
77SELECT @@global.sort_buffer_size;
78@@global.sort_buffer_size
794294967295
80SET @@session.sort_buffer_size = 32775;
81SELECT @@session.sort_buffer_size;
82@@session.sort_buffer_size
8332775
84SET @@session.sort_buffer_size = -2;
85SELECT @@session.sort_buffer_size;
86@@session.sort_buffer_size
8732768
88SET @@session.sort_buffer_size = 65530.34;
89ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
90SET @@session.sort_buffer_size = 4294967296;
91SELECT @@session.sort_buffer_size;
92@@session.sort_buffer_size
934294967295
94SET @@session.sort_buffer_size = test;
95ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
96'#------------------FN_DYNVARS_151_06-----------------------#'
97SELECT @@global.sort_buffer_size = VARIABLE_VALUE FROM
98INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size';
99@@global.sort_buffer_size = VARIABLE_VALUE
1001
101'#------------------FN_DYNVARS_151_07-----------------------#'
102SELECT @@session.sort_buffer_size = VARIABLE_VALUE FROM
103INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size';
104@@session.sort_buffer_size = VARIABLE_VALUE
1051
106'#------------------FN_DYNVARS_151_08-----------------------#'
107SET @@global.sort_buffer_size = TRUE;
108SELECT @@global.sort_buffer_size;
109@@global.sort_buffer_size
11032768
111SET @@global.sort_buffer_size = FALSE;
112SELECT @@global.sort_buffer_size;
113@@global.sort_buffer_size
11432768
115'#---------------------FN_DYNVARS_151_09----------------------#'
116SET @@global.sort_buffer_size = 9000;
117SELECT @@sort_buffer_size = @@global.sort_buffer_size;
118@@sort_buffer_size = @@global.sort_buffer_size
1190
120'#---------------------FN_DYNVARS_151_10----------------------#'
121SET @@sort_buffer_size = 9000;
122SELECT @@sort_buffer_size = @@local.sort_buffer_size;
123@@sort_buffer_size = @@local.sort_buffer_size
1241
125SELECT @@local.sort_buffer_size = @@session.sort_buffer_size;
126@@local.sort_buffer_size = @@session.sort_buffer_size
1271
128'#---------------------FN_DYNVARS_151_11----------------------#'
129SET sort_buffer_size = 9100;
130SELECT @@sort_buffer_size;
131@@sort_buffer_size
13232768
133SELECT local.sort_buffer_size;
134ERROR 42S02: Unknown table 'local' in field list
135SELECT session.sort_buffer_size;
136ERROR 42S02: Unknown table 'session' in field list
137SELECT sort_buffer_size = @@session.sort_buffer_size;
138ERROR 42S22: Unknown column 'sort_buffer_size' in 'field list'
139SET @@global.sort_buffer_size = @start_global_value;
140SET @@session.sort_buffer_size = @start_session_value;
141