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 Warnings:
5 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
6 CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY, val TEXT(200));
7 INSERT INTO t1 VALUES(NULL,'a');
8 INSERT INTO t1 VALUES(NULL,'b');
9 INSERT INTO t1 VALUES(NULL,'c');
10 INSERT INTO t1 VALUES(NULL,'d');
11 SELECT * FROM t1 ORDER BY val;
12 id val
13 1 a
14 2 b
15 3 c
16 4 d
17 SET SESSION query_prealloc_size = 8192;
18 Warnings:
19 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
20 '#----------------------------FN_DYNVARS_137_05-----------------#'
21 SET GLOBAL query_prealloc_size = 8192;
22 Warnings:
23 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
24 SELECT @@SESSION.query_prealloc_size;
25 @@SESSION.query_prealloc_size
26 8192
27 Warnings:
28 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
29 Expected Value : 8192;
30 SET SESSION query_prealloc_size = 16384;
31 Warnings:
32 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
33 SELECT @@SESSION.query_prealloc_size;
34 @@SESSION.query_prealloc_size
35 8192
36 Warnings:
37 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
38 Expected Value : 8192;
39 SET SESSION query_prealloc_size = 8192;
40 Warnings:
41 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
42 SELECT @@SESSION.query_prealloc_size;
43 @@SESSION.query_prealloc_size
44 16384
45 Warnings:
46 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
47 Expected Value : 16384;
48 SELECT @@SESSION.query_prealloc_size;
49 @@SESSION.query_prealloc_size
50 8192
51 Warnings:
52 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
53 Expected Value : 8192;
54 SELECT @@GLOBAL.query_prealloc_size;
55 @@GLOBAL.query_prealloc_size
56 8192
57 Warnings:
58 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
59 Expected Value : 8192;
60 DROP TABLE t1;
61 SET @@global.query_prealloc_size = @start_value;
62 Warnings:
63 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.