3
CREATE TABLE t1 (id int auto_increment primary key, val text(200));
4
INSERT INTO t1 values(NULL,'a');
5
INSERT INTO t1 values(NULL,'b');
6
INSERT INTO t1 values(NULL,'c');
7
INSERT INTO t1 values(NULL,'d');
8
SELECT * FROM t1 ORDER BY val;
14
SET SESSION query_prealloc_size = 8192;
15
'#----------------------------FN_DYNVARS_137_05-----------------#'
16
SET GLOBAL query_prealloc_size = 8192;
17
SELECT @@SESSION.query_prealloc_size;
18
@@SESSION.query_prealloc_size
20
Expected Value : 8192;
21
SET SESSION query_prealloc_size = 16384;
22
SELECT @@SESSION.query_prealloc_size;
23
@@SESSION.query_prealloc_size
25
Expected Value : 8192;
26
SET SESSION query_prealloc_size = 8192;
27
SELECT @@SESSION.query_prealloc_size;
28
@@SESSION.query_prealloc_size
30
Expected Value : 16384;
31
SELECT @@SESSION.query_prealloc_size;
32
@@SESSION.query_prealloc_size
34
Expected Value : 8192;
35
SELECT @@GLOBAL.query_prealloc_size;
36
@@GLOBAL.query_prealloc_size
38
Expected Value : 8192;