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;
18connect  con_int1,localhost,root,,;
19connection con_int1;
20SELECT @@SESSION.query_prealloc_size;
21@@SESSION.query_prealloc_size
228192
23Expected Value : 8192;
24SET SESSION query_prealloc_size = 16384;
25connect  con_int2,localhost,root,,;
26connection con_int2;
27SELECT @@SESSION.query_prealloc_size;
28@@SESSION.query_prealloc_size
298192
30Expected Value : 8192;
31SET SESSION query_prealloc_size = 8192;
32connection con_int1;
33SELECT @@SESSION.query_prealloc_size;
34@@SESSION.query_prealloc_size
3516384
36Expected Value : 16384;
37connection con_int2;
38SELECT @@SESSION.query_prealloc_size;
39@@SESSION.query_prealloc_size
408192
41Expected Value : 8192;
42SELECT @@GLOBAL.query_prealloc_size;
43@@GLOBAL.query_prealloc_size
448192
45Expected Value : 8192;
46connection default;
47disconnect con_int1;
48disconnect con_int2;
49DROP TABLE t1;
50SET @@global.query_prealloc_size = @start_value;
51