1** Setup **
2
3SET @start_value = @@global.query_prealloc_size;
4CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY, val TEXT(200));
5INSERT INTO t1 VALUES(NULL,'a');
6INSERT INTO t1 VALUES(NULL,'b');
7INSERT INTO t1 VALUES(NULL,'c');
8INSERT INTO t1 VALUES(NULL,'d');
9SELECT * FROM t1 ORDER BY val;
10id	val
111	a
122	b
133	c
144	d
15SET SESSION query_prealloc_size = 8192;
16'#----------------------------FN_DYNVARS_137_05-----------------#'
17SET GLOBAL query_prealloc_size = 8192;
18SELECT @@SESSION.query_prealloc_size;
19@@SESSION.query_prealloc_size
208192
21Expected Value : 8192;
22SET SESSION query_prealloc_size = 16384;
23SELECT @@SESSION.query_prealloc_size;
24@@SESSION.query_prealloc_size
258192
26Expected Value : 8192;
27SET SESSION query_prealloc_size = 8192;
28SELECT @@SESSION.query_prealloc_size;
29@@SESSION.query_prealloc_size
3016384
31Expected Value : 16384;
32SELECT @@SESSION.query_prealloc_size;
33@@SESSION.query_prealloc_size
348192
35Expected Value : 8192;
36SELECT @@GLOBAL.query_prealloc_size;
37@@GLOBAL.query_prealloc_size
388192
39Expected Value : 8192;
40DROP TABLE t1;
41SET @@global.query_prealloc_size = @start_value;
42