1SET @start_value = @@global.query_cache_size;
2'#--------------------FN_DYNVARS_133_01------------------------#'
3SET @@global.query_cache_size = 99;
4Warnings:
5Warning	1292	Truncated incorrect query_cache_size value: '99'
6SET @@global.query_cache_size = DEFAULT;
7SELECT @@global.query_cache_size;
8@@global.query_cache_size
91048576
10'#---------------------FN_DYNVARS_133_02-------------------------#'
11SET @@global.query_cache_size = @start_value;
12SELECT @@global.query_cache_size = @start_value;
13@@global.query_cache_size = @start_value
141
15'#--------------------FN_DYNVARS_133_03------------------------#'
16SET @@global.query_cache_size = 0;
17SELECT @@global.query_cache_size;
18@@global.query_cache_size
190
20SET @@global.query_cache_size = 1;
21Warnings:
22Warning	1292	Truncated incorrect query_cache_size value: '1'
23SELECT @@global.query_cache_size;
24@@global.query_cache_size
250
26SET @@global.query_cache_size = 512;
27Warnings:
28Warning	1292	Truncated incorrect query_cache_size value: '512'
29SELECT @@global.query_cache_size;
30@@global.query_cache_size
310
32SET @@global.query_cache_size = 1024;
33Warnings:
34Warning	1282	Query cache failed to set size 1024; new query cache size is 0
35SELECT @@global.query_cache_size;
36@@global.query_cache_size
370
38SET @@global.query_cache_size = 1048576;
39SELECT @@global.query_cache_size;
40@@global.query_cache_size
411048576
42SET @@global.query_cache_size = 1048575;
43Warnings:
44Warning	1292	Truncated incorrect query_cache_size value: '1048575'
45SELECT @@global.query_cache_size;
46@@global.query_cache_size
471047552
48'#--------------------FN_DYNVARS_133_04-------------------------#'
49SET @@global.query_cache_size = -1;
50Warnings:
51Warning	1292	Truncated incorrect query_cache_size value: '-1'
52SELECT @@global.query_cache_size;
53@@global.query_cache_size
540
55SET @@global.query_cache_size = 511;
56Warnings:
57Warning	1292	Truncated incorrect query_cache_size value: '511'
58SELECT @@global.query_cache_size;
59@@global.query_cache_size
600
61SET @@global.query_cache_size = 10000.01;
62ERROR 42000: Incorrect argument type to variable 'query_cache_size'
63SELECT @@global.query_cache_size;
64@@global.query_cache_size
650
66SET @@global.query_cache_size = -1024;
67Warnings:
68Warning	1292	Truncated incorrect query_cache_size value: '-1024'
69SELECT @@global.query_cache_size;
70@@global.query_cache_size
710
72SET @@global.query_cache_size = 42949672950;
73Warnings:
74Warning	1292	Truncated incorrect query_cache_size value: '42949672950'
75Warning	1282	Query cache failed to set size 42949671936; new query cache size is 0
76SELECT @@global.query_cache_size;
77@@global.query_cache_size
780
79SET @@global.query_cache_size = ON;
80ERROR 42000: Incorrect argument type to variable 'query_cache_size'
81SELECT @@global.query_cache_size;
82@@global.query_cache_size
830
84SET @@global.query_cache_size = 'test';
85ERROR 42000: Incorrect argument type to variable 'query_cache_size'
86SELECT @@global.query_cache_size;
87@@global.query_cache_size
880
89'#-------------------FN_DYNVARS_133_05----------------------------#'
90SET @@session.query_cache_size = 0;
91ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
92SELECT @@query_cache_size;
93@@query_cache_size
940
95'#----------------------FN_DYNVARS_133_06------------------------#'
96SELECT @@global.query_cache_size = VARIABLE_VALUE
97FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
98WHERE VARIABLE_NAME='query_cache_size';
99@@global.query_cache_size = VARIABLE_VALUE
1001
101SELECT @@query_cache_size = VARIABLE_VALUE
102FROM INFORMATION_SCHEMA.SESSION_VARIABLES
103WHERE VARIABLE_NAME='query_cache_size';
104@@query_cache_size = VARIABLE_VALUE
1051
106'#---------------------FN_DYNVARS_133_07----------------------#'
107SET @@global.query_cache_size = TRUE;
108Warnings:
109Warning	1292	Truncated incorrect query_cache_size value: '1'
110SELECT @@global.query_cache_size;
111@@global.query_cache_size
1120
113SET @@global.query_cache_size = FALSE;
114SELECT @@global.query_cache_size;
115@@global.query_cache_size
1160
117'#---------------------FN_DYNVARS_133_08----------------------#'
118SET @@global.query_cache_size = 1;
119Warnings:
120Warning	1292	Truncated incorrect query_cache_size value: '1'
121SELECT @@query_cache_size = @@global.query_cache_size;
122@@query_cache_size = @@global.query_cache_size
1231
124'#---------------------FN_DYNVARS_133_09----------------------#'
125SET query_cache_size = 1;
126ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
127SELECT @@query_cache_size;
128@@query_cache_size
1290
130SET local.query_cache_size = 1;
131ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'query_cache_size = 1' at line 1
132SELECT local.query_cache_size;
133ERROR 42S02: Unknown table 'local' in field list
134SET global.query_cache_size = 1;
135ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'query_cache_size = 1' at line 1
136SELECT global.query_cache_size;
137ERROR 42S02: Unknown table 'global' in field list
138SELECT query_cache_size = @@session.query_cache_size;
139ERROR 42S22: Unknown column 'query_cache_size' in 'field list'
140SET @@global.query_cache_size = @start_value;
141