Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.query_prealloc_size ;
2 SELECT @start_global_value;
3 @start_global_value
4 32768
5 SET @start_session_value = @@session.query_prealloc_size ;
6 SELECT @start_session_value;
7 @start_session_value
8 32768
9 '#--------------------FN_DYNVARS_005_01-------------------------#'
10 SET @@global.query_prealloc_size = 100;
11 Warnings:
12 Warning 1292 Truncated incorrect query_prealloc_size value: '100'
13 SET @@global.query_prealloc_size = DEFAULT;
14 SELECT @@global.query_prealloc_size ;
15 @@global.query_prealloc_size
16 32768
17 SET @@session.query_prealloc_size = 200;
18 Warnings:
19 Warning 1292 Truncated incorrect query_prealloc_size value: '200'
20 SET @@session.query_prealloc_size = DEFAULT;
21 SELECT @@session.query_prealloc_size ;
22 @@session.query_prealloc_size
23 32768
24 '#--------------------FN_DYNVARS_005_02-------------------------#'
25 SET @@global.query_prealloc_size = DEFAULT;
26 SELECT @@global.query_prealloc_size = 32768;
27 @@global.query_prealloc_size = 32768
28 1
29 SET @@session.query_prealloc_size = DEFAULT;
30 SELECT @@session.query_prealloc_size = 32768;
31 @@session.query_prealloc_size = 32768
32 1
33 '#--------------------FN_DYNVARS_005_03-------------------------#'
34 SET @@global.query_prealloc_size = 8192;
35 SELECT @@global.query_prealloc_size ;
36 @@global.query_prealloc_size
37 8192
38 SET @@global.query_prealloc_size = 655354;
39 Warnings:
40 Warning 1292 Truncated incorrect query_prealloc_size value: '655354'
41 SELECT @@global.query_prealloc_size ;
42 @@global.query_prealloc_size
43 654336
44 '#--------------------FN_DYNVARS_005_04-------------------------#'
45 SET @@session.query_prealloc_size = 8192;
46 SELECT @@session.query_prealloc_size ;
47 @@session.query_prealloc_size
48 8192
49 SET @@session.query_prealloc_size = 655345;
50 Warnings:
51 Warning 1292 Truncated incorrect query_prealloc_size value: '655345'
52 SELECT @@session.query_prealloc_size ;
53 @@session.query_prealloc_size
54 654336
55 '#------------------FN_DYNVARS_005_05-----------------------#'
56 SET @@global.query_prealloc_size = 0;
57 Warnings:
58 Warning 1292 Truncated incorrect query_prealloc_size value: '0'
59 SELECT @@global.query_prealloc_size ;
60 @@global.query_prealloc_size
61 1024
62 SET @@global.query_prealloc_size = 65530.34;
63 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
64 SELECT @@global.query_prealloc_size ;
65 @@global.query_prealloc_size
66 1024
67 SET @@global.query_prealloc_size = test;
68 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
69 SELECT @@global.query_prealloc_size ;
70 @@global.query_prealloc_size
71 1024
72 SET @@global.query_prealloc_size = "test";
73 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
74 SELECT @@global.query_prealloc_size ;
75 @@global.query_prealloc_size
76 1024
77 SET @@global.query_prealloc_size = 'test';
78 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
79 SELECT @@global.query_prealloc_size ;
80 @@global.query_prealloc_size
81 1024
82 SET @@global.query_prealloc_size = ON;
83 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
84 SELECT @@global.query_prealloc_size ;
85 @@global.query_prealloc_size
86 1024
87 SET @@session.query_prealloc_size = 0;
88 Warnings:
89 Warning 1292 Truncated incorrect query_prealloc_size value: '0'
90 SELECT @@session.query_prealloc_size ;
91 @@session.query_prealloc_size
92 1024
93 SET @@session.query_prealloc_size = 65530.34;
94 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
95 SELECT @@session.query_prealloc_size ;
96 @@session.query_prealloc_size
97 1024
98 SET @@session.query_prealloc_size = test;
99 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
100 SELECT @@session.query_prealloc_size ;
101 @@session.query_prealloc_size
102 1024
103 SET @@session.query_prealloc_size = "test";
104 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
105 SELECT @@session.query_prealloc_size ;
106 @@session.query_prealloc_size
107 1024
108 '#------------------FN_DYNVARS_005_06-----------------------#'
109 SELECT @@global.query_prealloc_size = VARIABLE_VALUE
110 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
111 WHERE VARIABLE_NAME='query_prealloc_size ';
112 @@global.query_prealloc_size = VARIABLE_VALUE
113 1
114 '#------------------FN_DYNVARS_005_07-----------------------#'
115 SELECT @@session.query_prealloc_size = VARIABLE_VALUE
116 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
117 WHERE VARIABLE_NAME='query_prealloc_size ';
118 @@session.query_prealloc_size = VARIABLE_VALUE
119 1
120 '#------------------FN_DYNVARS_005_08-----------------------#'
121 SET @@global.query_prealloc_size = TRUE;
122 Warnings:
123 Warning 1292 Truncated incorrect query_prealloc_size value: '1'
124 SELECT @@global.query_prealloc_size ;
125 @@global.query_prealloc_size
126 1024
127 SET @@global.query_prealloc_size = FALSE;
128 Warnings:
129 Warning 1292 Truncated incorrect query_prealloc_size value: '0'
130 SELECT @@global.query_prealloc_size ;
131 @@global.query_prealloc_size
132 1024
133 '#---------------------FN_DYNVARS_001_09----------------------#'
134 SET @@global.query_prealloc_size = 10;
135 Warnings:
136 Warning 1292 Truncated incorrect query_prealloc_size value: '10'
137 SELECT @@query_prealloc_size = @@global.query_prealloc_size ;
138 @@query_prealloc_size = @@global.query_prealloc_size
139 1
140 '#---------------------FN_DYNVARS_001_10----------------------#'
141 SET @@query_prealloc_size = 100;
142 Warnings:
143 Warning 1292 Truncated incorrect query_prealloc_size value: '100'
144 SELECT @@query_prealloc_size = @@local.query_prealloc_size ;
145 @@query_prealloc_size = @@local.query_prealloc_size
146 1
147 SELECT @@local.query_prealloc_size = @@session.query_prealloc_size ;
148 @@local.query_prealloc_size = @@session.query_prealloc_size
149 1
150 '#---------------------FN_DYNVARS_001_11----------------------#'
151 SET query_prealloc_size = 1;
152 Warnings:
153 Warning 1292 Truncated incorrect query_prealloc_size value: '1'
154 SELECT @@query_prealloc_size ;
155 @@query_prealloc_size
156 1024
157 SELECT local.query_prealloc_size ;
158 ERROR 42S02: Unknown table 'local' in SELECT
159 SELECT session.query_prealloc_size ;
160 ERROR 42S02: Unknown table 'session' in SELECT
161 SELECT query_prealloc_size = @@session.query_prealloc_size ;
162 ERROR 42S22: Unknown column 'query_prealloc_size' in 'SELECT'
163 SET @@global.query_prealloc_size = @start_global_value;
164 SELECT @@global.query_prealloc_size ;
165 @@global.query_prealloc_size
166 32768
167 SET @@session.query_prealloc_size = @start_session_value;
168 SELECT @@session.query_prealloc_size ;
169 @@session.query_prealloc_size
170 32768