Debian Codegraph @

mysql-test/suite/sys_vars/r/query_prealloc_size_func.result

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