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