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
82097152
9SET @@session.sort_buffer_size = 2000;
10SET @@session.sort_buffer_size = DEFAULT;
11SELECT @@session.sort_buffer_size;
12@@session.sort_buffer_size
132097152
14'#--------------------FN_DYNVARS_151_02-------------------------#'
15SET @@global.sort_buffer_size = DEFAULT;
16SELECT @@global.sort_buffer_size;
17@@global.sort_buffer_size
182097152
19SET @@session.sort_buffer_size = DEFAULT;
20SELECT @@session.sort_buffer_size;
21@@session.sort_buffer_size
222097152
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
651024
66SET @@global.sort_buffer_size = 4294967296;
67SELECT @@global.sort_buffer_size;
68@@global.sort_buffer_size
69max_sort_buffer_size
70SET @@global.sort_buffer_size = 1024*1024;
71SET @@global.sort_buffer_size = 65530.34;
72ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
73SELECT @@global.sort_buffer_size;
74@@global.sort_buffer_size
751048576
76SET @@global.sort_buffer_size = test;
77ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
78SELECT @@global.sort_buffer_size;
79@@global.sort_buffer_size
801048576
81SET @@session.sort_buffer_size = 32775;
82SELECT @@session.sort_buffer_size;
83@@session.sort_buffer_size
8432775
85SET @@session.sort_buffer_size = -2;
86SELECT @@session.sort_buffer_size;
87@@session.sort_buffer_size
881024
89SET @@session.sort_buffer_size = 65530.34;
90ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
91SET @@session.sort_buffer_size = 4294967295;
92SELECT @@session.sort_buffer_size;
93@@session.sort_buffer_size
944294967295
95SET @@session.sort_buffer_size = test;
96ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
97'#------------------FN_DYNVARS_151_06-----------------------#'
98SELECT @@global.sort_buffer_size = VARIABLE_VALUE FROM
99INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size';
100@@global.sort_buffer_size = VARIABLE_VALUE
1011
102'#------------------FN_DYNVARS_151_07-----------------------#'
103SELECT @@session.sort_buffer_size = VARIABLE_VALUE FROM
104INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size';
105@@session.sort_buffer_size = VARIABLE_VALUE
1061
107'#------------------FN_DYNVARS_151_08-----------------------#'
108SET @@global.sort_buffer_size = TRUE;
109SELECT @@global.sort_buffer_size;
110@@global.sort_buffer_size
1111024
112SET @@global.sort_buffer_size = FALSE;
113SELECT @@global.sort_buffer_size;
114@@global.sort_buffer_size
1151024
116'#---------------------FN_DYNVARS_151_09----------------------#'
117SET @@global.sort_buffer_size = 9000;
118SELECT @@sort_buffer_size = @@global.sort_buffer_size;
119@@sort_buffer_size = @@global.sort_buffer_size
1200
121'#---------------------FN_DYNVARS_151_10----------------------#'
122SET @@sort_buffer_size = 9000;
123SELECT @@sort_buffer_size = @@local.sort_buffer_size;
124@@sort_buffer_size = @@local.sort_buffer_size
1251
126SELECT @@local.sort_buffer_size = @@session.sort_buffer_size;
127@@local.sort_buffer_size = @@session.sort_buffer_size
1281
129'#---------------------FN_DYNVARS_151_11----------------------#'
130SET sort_buffer_size = 9100;
131SELECT @@sort_buffer_size;
132@@sort_buffer_size
1339100
134SELECT local.sort_buffer_size;
135ERROR 42S02: Unknown table 'local' in field list
136SELECT session.sort_buffer_size;
137ERROR 42S02: Unknown table 'session' in field list
138SELECT sort_buffer_size = @@session.sort_buffer_size;
139ERROR 42S22: Unknown column 'sort_buffer_size' in 'field list'
140SET @@global.sort_buffer_size = @start_global_value;
141SET @@session.sort_buffer_size = @start_session_value;
142