Debian Codegraph @

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

raw
1 SET @start_value = @@global.query_cache_min_res_unit;
2 SELECT @start_value;
3 @start_value
4 4096
5 '#--------------------FN_DYNVARS_132_01------------------------#'
6 SET @@global.query_cache_min_res_unit = 99;
7 Warnings:
8 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '99'
9 SET @@global.query_cache_min_res_unit = DEFAULT;
10 SELECT @@global.query_cache_min_res_unit;
11 @@global.query_cache_min_res_unit
12 4096
13 '#---------------------FN_DYNVARS_132_02-------------------------#'
14 SET @@global.query_cache_min_res_unit = @start_value;
15 SELECT @@global.query_cache_min_res_unit = 4096;
16 @@global.query_cache_min_res_unit = 4096
17 1
18 '#--------------------FN_DYNVARS_132_03------------------------#'
19 SET @@global.query_cache_min_res_unit = 0;
20 SELECT @@global.query_cache_min_res_unit;
21 @@global.query_cache_min_res_unit
22 512
23 SET @@global.query_cache_min_res_unit = 1;
24 Warnings:
25 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '1'
26 SELECT @@global.query_cache_min_res_unit;
27 @@global.query_cache_min_res_unit
28 512
29 SET @@global.query_cache_min_res_unit = 512;
30 SELECT @@global.query_cache_min_res_unit;
31 @@global.query_cache_min_res_unit
32 512
33 SET @@global.query_cache_min_res_unit = 513;
34 Warnings:
35 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '513'
36 SELECT @@global.query_cache_min_res_unit;
37 @@global.query_cache_min_res_unit
38 512
39 SET @@global.query_cache_min_res_unit = 1048576;
40 SELECT @@global.query_cache_min_res_unit;
41 @@global.query_cache_min_res_unit
42 1048576
43 SET @@global.query_cache_min_res_unit = 1048575;
44 Warnings:
45 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '1048575'
46 SELECT @@global.query_cache_min_res_unit;
47 @@global.query_cache_min_res_unit
48 1048568
49 '#--------------------FN_DYNVARS_132_04-------------------------#'
50 SET @@global.query_cache_min_res_unit = -1;
51 Warnings:
52 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1'
53 SELECT @@global.query_cache_min_res_unit;
54 @@global.query_cache_min_res_unit
55 512
56 SET @@global.query_cache_min_res_unit = 4294967296;
57 Warnings:
58 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '4294967296'
59 SELECT @@global.query_cache_min_res_unit;
60 @@global.query_cache_min_res_unit
61 4294967288
62 SET @@global.query_cache_min_res_unit = 511;
63 Warnings:
64 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '511'
65 SELECT @@global.query_cache_min_res_unit;
66 @@global.query_cache_min_res_unit
67 512
68 SET @@global.query_cache_min_res_unit = 10000.01;
69 ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit'
70 SELECT @@global.query_cache_min_res_unit;
71 @@global.query_cache_min_res_unit
72 512
73 SET @@global.query_cache_min_res_unit = -1024;
74 Warnings:
75 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1024'
76 SELECT @@global.query_cache_min_res_unit;
77 @@global.query_cache_min_res_unit
78 512
79 SET @@global.query_cache_min_res_unit = 42949672950;
80 Warnings:
81 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '42949672950'
82 SELECT @@global.query_cache_min_res_unit;
83 @@global.query_cache_min_res_unit
84 4294967288
85 SET @@global.query_cache_min_res_unit = ON;
86 ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit'
87 SELECT @@global.query_cache_min_res_unit;
88 @@global.query_cache_min_res_unit
89 4294967288
90 SET @@global.query_cache_min_res_unit = 'test';
91 ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit'
92 SELECT @@global.query_cache_min_res_unit;
93 @@global.query_cache_min_res_unit
94 4294967288
95 '#-------------------FN_DYNVARS_132_05----------------------------#'
96 SET @@session.query_cache_min_res_unit = 0;
97 ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL
98 SELECT @@query_cache_min_res_unit;
99 @@query_cache_min_res_unit
100 4294967288
101 '#----------------------FN_DYNVARS_132_06------------------------#'
102 SELECT @@global.query_cache_min_res_unit = VARIABLE_VALUE
103 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
104 WHERE VARIABLE_NAME='query_cache_min_res_unit';
105 @@global.query_cache_min_res_unit = VARIABLE_VALUE
106 1
107 SELECT @@query_cache_min_res_unit = VARIABLE_VALUE
108 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
109 WHERE VARIABLE_NAME='query_cache_min_res_unit';
110 @@query_cache_min_res_unit = VARIABLE_VALUE
111 1
112 '#---------------------FN_DYNVARS_132_07----------------------#'
113 SET @@global.query_cache_min_res_unit = TRUE;
114 Warnings:
115 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '1'
116 SELECT @@global.query_cache_min_res_unit;
117 @@global.query_cache_min_res_unit
118 512
119 SET @@global.query_cache_min_res_unit = FALSE;
120 SELECT @@global.query_cache_min_res_unit;
121 @@global.query_cache_min_res_unit
122 512
123 '#---------------------FN_DYNVARS_132_08----------------------#'
124 SET @@global.query_cache_min_res_unit = 1;
125 Warnings:
126 Warning 1292 Truncated incorrect query_cache_min_res_unit value: '1'
127 SELECT @@query_cache_min_res_unit = @@global.query_cache_min_res_unit;
128 @@query_cache_min_res_unit = @@global.query_cache_min_res_unit
129 1
130 '#---------------------FN_DYNVARS_132_09----------------------#'
131 SET query_cache_min_res_unit = 1;
132 ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL
133 SELECT @@query_cache_min_res_unit;
134 @@query_cache_min_res_unit
135 512
136 SELECT local.query_cache_min_res_unit;
137 ERROR 42S02: Unknown table 'local' in SELECT
138 SELECT global.query_cache_min_res_unit;
139 ERROR 42S02: Unknown table 'global' in SELECT
140 SELECT query_cache_min_res_unit = @@session.query_cache_min_res_unit;
141 ERROR 42S22: Unknown column 'query_cache_min_res_unit' in 'SELECT'
142 SET @@global.query_cache_min_res_unit = @start_value;
143 SELECT @@global.query_cache_min_res_unit;
144 @@global.query_cache_min_res_unit
145 4096