1SET @start_value = @@global.query_cache_limit;
2SELECT @start_value;
3@start_value
41048576
5'#--------------------FN_DYNVARS_131_01------------------------#'
6SET @@global.query_cache_limit = 99;
7SET @@global.query_cache_limit = DEFAULT;
8SELECT @@global.query_cache_limit;
9@@global.query_cache_limit
101048576
11'#---------------------FN_DYNVARS_131_02-------------------------#'
12SET @@global.query_cache_limit = @start_value;
13SELECT @@global.query_cache_limit = 1048576;
14@@global.query_cache_limit = 1048576
151
16'#--------------------FN_DYNVARS_131_03------------------------#'
17SET @@global.query_cache_limit = 0;
18SELECT @@global.query_cache_limit;
19@@global.query_cache_limit
200
21SET @@global.query_cache_limit = 1;
22SELECT @@global.query_cache_limit;
23@@global.query_cache_limit
241
25SET @@global.query_cache_limit = 1048576;
26SELECT @@global.query_cache_limit;
27@@global.query_cache_limit
281048576
29SET @@global.query_cache_limit = 1048575;
30SELECT @@global.query_cache_limit;
31@@global.query_cache_limit
321048575
33'#--------------------FN_DYNVARS_131_04-------------------------#'
34SET @@global.query_cache_limit = -1;
35Warnings:
36Warning	1292	Truncated incorrect query_cache_limit value: '-1'
37SELECT @@global.query_cache_limit;
38@@global.query_cache_limit
390
40SET @@global.query_cache_limit = 4294967296;
41Warnings:
42Warning	1292	Truncated incorrect query_cache_limit value: '4294967296'
43SELECT @@global.query_cache_limit;
44@@global.query_cache_limit
454294967295
46SET @@global.query_cache_limit = 10240022115;
47Warnings:
48Warning	1292	Truncated incorrect query_cache_limit value: '10240022115'
49SELECT @@global.query_cache_limit;
50@@global.query_cache_limit
514294967295
52SET @@global.query_cache_limit = 10000.01;
53ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
54SELECT @@global.query_cache_limit;
55@@global.query_cache_limit
564294967295
57SET @@global.query_cache_limit = -1024;
58Warnings:
59Warning	1292	Truncated incorrect query_cache_limit value: '-1024'
60SELECT @@global.query_cache_limit;
61@@global.query_cache_limit
620
63SET @@global.query_cache_limit = 42949672950;
64Warnings:
65Warning	1292	Truncated incorrect query_cache_limit value: '42949672950'
66SELECT @@global.query_cache_limit;
67@@global.query_cache_limit
684294967295
69SET @@global.query_cache_limit = ON;
70ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
71SELECT @@global.query_cache_limit;
72@@global.query_cache_limit
734294967295
74SET @@global.query_cache_limit = 'test';
75ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
76SELECT @@global.query_cache_limit;
77@@global.query_cache_limit
784294967295
79'#-------------------FN_DYNVARS_131_05----------------------------#'
80SET @@session.query_cache_limit = 0;
81ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL
82SELECT @@query_cache_limit;
83@@query_cache_limit
844294967295
85'#----------------------FN_DYNVARS_131_06------------------------#'
86SELECT @@global.query_cache_limit = VARIABLE_VALUE
87FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
88WHERE VARIABLE_NAME='query_cache_limit';
89@@global.query_cache_limit = VARIABLE_VALUE
901
91SELECT @@query_cache_limit = VARIABLE_VALUE
92FROM INFORMATION_SCHEMA.SESSION_VARIABLES
93WHERE VARIABLE_NAME='query_cache_limit';
94@@query_cache_limit = VARIABLE_VALUE
951
96'#---------------------FN_DYNVARS_131_07----------------------#'
97SET @@global.query_cache_limit = TRUE;
98SELECT @@global.query_cache_limit;
99@@global.query_cache_limit
1001
101SET @@global.query_cache_limit = FALSE;
102SELECT @@global.query_cache_limit;
103@@global.query_cache_limit
1040
105'#---------------------FN_DYNVARS_131_08----------------------#'
106SET @@global.query_cache_limit = 1;
107SELECT @@query_cache_limit = @@global.query_cache_limit;
108@@query_cache_limit = @@global.query_cache_limit
1091
110'#---------------------FN_DYNVARS_131_09----------------------#'
111SET query_cache_limit = 1;
112ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL
113SELECT @@query_cache_limit;
114@@query_cache_limit
1151
116SELECT local.query_cache_limit;
117ERROR 42S02: Unknown table 'local' in field list
118SELECT global.query_cache_limit;
119ERROR 42S02: Unknown table 'global' in field list
120SELECT query_cache_limit = @@session.query_cache_limit;
121ERROR 42S22: Unknown column 'query_cache_limit' in 'field list'
122SET @@global.query_cache_limit = @start_value;
123SELECT @@global.query_cache_limit;
124@@global.query_cache_limit
1251048576
126