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