1
SET @start_global_value = @@global.sort_buffer_size;
2
SET @start_session_value = @@session.sort_buffer_size;
3
'#--------------------FN_DYNVARS_151_01-------------------------#'
4
SET @@global.sort_buffer_size = 1000;
5
SET @@global.sort_buffer_size = DEFAULT;
6
SELECT @@global.sort_buffer_size BETWEEN 2097116 AND 2100000;
7
@@global.sort_buffer_size BETWEEN 2097116 AND 2100000
9
SET @@session.sort_buffer_size = 2000;
10
SET @@session.sort_buffer_size = DEFAULT;
11
SELECT @@session.sort_buffer_size BETWEEN 2097116 AND 2100000;
12
@@session.sort_buffer_size BETWEEN 2097116 AND 2100000
14
'#--------------------FN_DYNVARS_151_02-------------------------#'
15
SET @@global.sort_buffer_size = DEFAULT;
16
SELECT @@global.sort_buffer_size BETWEEN 2097116 AND 2100000;
17
@@global.sort_buffer_size BETWEEN 2097116 AND 2100000
19
SET @@session.sort_buffer_size = DEFAULT;
20
SELECT @@session.sort_buffer_size BETWEEN 2097116 AND 2100000;
21
@@session.sort_buffer_size BETWEEN 2097116 AND 2100000
23
'#--------------------FN_DYNVARS_151_03-------------------------#'
24
SET @@global.sort_buffer_size = 32776;
25
SELECT @@global.sort_buffer_size BETWEEN 32776 AND 32999;
26
@@global.sort_buffer_size BETWEEN 32776 AND 32999
28
SET @@global.sort_buffer_size = 32777;
29
SELECT @@global.sort_buffer_size BETWEEN 32776 AND 32999;
30
@@global.sort_buffer_size BETWEEN 32776 AND 32999
32
SET @@global.sort_buffer_size = 4294967295;
33
SELECT @@global.sort_buffer_size;
34
@@global.sort_buffer_size
36
SET @@global.sort_buffer_size = 4294967294;
37
SELECT @@global.sort_buffer_size;
38
@@global.sort_buffer_size
40
'#--------------------FN_DYNVARS_151_04-------------------------#'
41
SET @@session.sort_buffer_size = 32776;
42
SELECT @@session.sort_buffer_size BETWEEN 32776 AND 32999;
43
@@session.sort_buffer_size BETWEEN 32776 AND 32999
45
SET @@session.sort_buffer_size = 32777;
46
SELECT @@session.sort_buffer_size BETWEEN 32776 AND 32999;
47
@@session.sort_buffer_size BETWEEN 32776 AND 32999
49
SET @@session.sort_buffer_size = 4294967295;
50
SELECT @@session.sort_buffer_size;
51
@@session.sort_buffer_size
53
SET @@session.sort_buffer_size = 4294967294;
54
SELECT @@session.sort_buffer_size;
55
@@session.sort_buffer_size
57
'#------------------FN_DYNVARS_151_05-----------------------#'
58
SET @@global.sort_buffer_size = 32775;
59
SELECT @@global.sort_buffer_size BETWEEN 32776 AND 32999;
60
@@global.sort_buffer_size BETWEEN 32776 AND 32999
62
SET @@global.sort_buffer_size = -1024;
63
SELECT @@global.sort_buffer_size BETWEEN 32776 AND 32999;
64
@@global.sort_buffer_size BETWEEN 32776 AND 32999
66
SET @@global.sort_buffer_size = 4294967296;
67
SELECT @@global.sort_buffer_size;
68
@@global.sort_buffer_size
70
SET @@global.sort_buffer_size = 65530.34.;
71
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
72
SELECT @@global.sort_buffer_size;
73
@@global.sort_buffer_size
75
SET @@global.sort_buffer_size = test;
76
ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
77
SELECT @@global.sort_buffer_size;
78
@@global.sort_buffer_size
80
SET @@session.sort_buffer_size = 32775;
81
SELECT @@session.sort_buffer_size BETWEEN 32776 AND 32999;
82
@@session.sort_buffer_size BETWEEN 32776 AND 32999
84
SET @@session.sort_buffer_size = -2;
85
SELECT @@session.sort_buffer_size BETWEEN 32776 AND 32999;
86
@@session.sort_buffer_size BETWEEN 32776 AND 32999
88
SET @@session.sort_buffer_size = 65530.34.;
89
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
90
SET @@session.sort_buffer_size = 4294967296;
91
SELECT @@session.sort_buffer_size;
92
@@session.sort_buffer_size
94
SET @@session.sort_buffer_size = test;
95
ERROR 42000: Incorrect argument type to variable 'sort_buffer_size'
96
'#------------------FN_DYNVARS_151_06-----------------------#'
97
SELECT @@global.sort_buffer_size = VARIABLE_VALUE FROM
98
INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size';
99
@@global.sort_buffer_size = VARIABLE_VALUE
101
'#------------------FN_DYNVARS_151_07-----------------------#'
102
SELECT @@session.sort_buffer_size = VARIABLE_VALUE FROM
103
INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size';
104
@@session.sort_buffer_size = VARIABLE_VALUE
106
'#------------------FN_DYNVARS_151_08-----------------------#'
107
SET @@global.sort_buffer_size = TRUE;
108
SELECT @@global.sort_buffer_size BETWEEN 32776 AND 32999;
109
@@global.sort_buffer_size BETWEEN 32776 AND 32999
111
SET @@global.sort_buffer_size = FALSE;
112
SELECT @@global.sort_buffer_size BETWEEN 32776 AND 32999;
113
@@global.sort_buffer_size BETWEEN 32776 AND 32999
115
'#---------------------FN_DYNVARS_151_09----------------------#'
116
SET @@global.sort_buffer_size = 9000;
117
SELECT @@sort_buffer_size = @@global.sort_buffer_size;
118
@@sort_buffer_size = @@global.sort_buffer_size
120
'#---------------------FN_DYNVARS_151_10----------------------#'
121
SET @@sort_buffer_size = 9000;
122
SELECT @@sort_buffer_size = @@local.sort_buffer_size;
123
@@sort_buffer_size = @@local.sort_buffer_size
125
SELECT @@local.sort_buffer_size = @@session.sort_buffer_size;
126
@@local.sort_buffer_size = @@session.sort_buffer_size
128
'#---------------------FN_DYNVARS_151_11----------------------#'
129
SET sort_buffer_size = 9100;
130
SELECT @@sort_buffer_size BETWEEN 32776 AND 32999;
131
@@sort_buffer_size BETWEEN 32776 AND 32999
133
SELECT local.sort_buffer_size;
134
ERROR 42S02: Unknown table 'local' in field list
135
SELECT session.sort_buffer_size;
136
ERROR 42S02: Unknown table 'session' in field list
137
SELECT sort_buffer_size = @@session.sort_buffer_size;
138
ERROR 42S22: Unknown column 'sort_buffer_size' in 'field list'
139
SET @@global.sort_buffer_size = @start_global_value;
140
SET @@session.sort_buffer_size = @start_session_value;