1
SET @start_value = @@global.query_cache_limit;
5
'#--------------------FN_DYNVARS_131_01------------------------#'
6
SET @@global.query_cache_limit = 99;
7
SET @@global.query_cache_limit = DEFAULT;
8
SELECT @@global.query_cache_limit;
9
@@global.query_cache_limit
11
'#---------------------FN_DYNVARS_131_02-------------------------#'
12
SET @@global.query_cache_limit = @start_value;
13
SELECT @@global.query_cache_limit = 1048576;
14
@@global.query_cache_limit = 1048576
16
'#--------------------FN_DYNVARS_131_03------------------------#'
17
SET @@global.query_cache_limit = 0;
18
SELECT @@global.query_cache_limit;
19
@@global.query_cache_limit
21
SET @@global.query_cache_limit = 1;
22
SELECT @@global.query_cache_limit;
23
@@global.query_cache_limit
25
SET @@global.query_cache_limit = 1048576;
26
SELECT @@global.query_cache_limit;
27
@@global.query_cache_limit
29
SET @@global.query_cache_limit = 1048575;
30
SELECT @@global.query_cache_limit;
31
@@global.query_cache_limit
33
'#--------------------FN_DYNVARS_131_04-------------------------#'
34
SET @@global.query_cache_limit = -1;
35
SELECT @@global.query_cache_limit;
36
@@global.query_cache_limit
38
SET @@global.query_cache_limit = 4294967296;
40
Warning 1292 Truncated incorrect query_cache_limit value: '4294967296'
41
SELECT @@global.query_cache_limit;
42
@@global.query_cache_limit
44
SET @@global.query_cache_limit = 10240022115;
46
Warning 1292 Truncated incorrect query_cache_limit value: '10240022115'
47
SELECT @@global.query_cache_limit;
48
@@global.query_cache_limit
50
SET @@global.query_cache_limit = 10000.01;
51
ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
52
SELECT @@global.query_cache_limit;
53
@@global.query_cache_limit
55
SET @@global.query_cache_limit = -1024;
56
SELECT @@global.query_cache_limit;
57
@@global.query_cache_limit
59
SET @@global.query_cache_limit = 42949672950;
61
Warning 1292 Truncated incorrect query_cache_limit value: '42949672950'
62
SELECT @@global.query_cache_limit;
63
@@global.query_cache_limit
65
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
66
SET @@global.query_cache_limit = ON;
67
ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
68
SELECT @@global.query_cache_limit;
69
@@global.query_cache_limit
71
SET @@global.query_cache_limit = 'test';
72
ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
73
SELECT @@global.query_cache_limit;
74
@@global.query_cache_limit
76
'#-------------------FN_DYNVARS_131_05----------------------------#'
77
SET @@session.query_cache_limit = 0;
78
ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL
79
SELECT @@query_cache_limit;
82
'#----------------------FN_DYNVARS_131_06------------------------#'
83
SELECT @@global.query_cache_limit = VARIABLE_VALUE
84
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
85
WHERE VARIABLE_NAME='query_cache_limit';
86
@@global.query_cache_limit = VARIABLE_VALUE
88
SELECT @@query_cache_limit = VARIABLE_VALUE
89
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
90
WHERE VARIABLE_NAME='query_cache_limit';
91
@@query_cache_limit = VARIABLE_VALUE
93
'#---------------------FN_DYNVARS_131_07----------------------#'
94
SET @@global.query_cache_limit = TRUE;
95
SELECT @@global.query_cache_limit;
96
@@global.query_cache_limit
98
SET @@global.query_cache_limit = FALSE;
99
SELECT @@global.query_cache_limit;
100
@@global.query_cache_limit
102
'#---------------------FN_DYNVARS_131_08----------------------#'
103
SET @@global.query_cache_limit = 1;
104
SELECT @@query_cache_limit = @@global.query_cache_limit;
105
@@query_cache_limit = @@global.query_cache_limit
107
'#---------------------FN_DYNVARS_131_09----------------------#'
108
SET query_cache_limit = 1;
109
ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL
110
SELECT @@query_cache_limit;
113
SET local.query_cache_limit = 1;
114
ERROR 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_limit = 1' at line 1
115
SELECT local.query_cache_limit;
116
ERROR 42S02: Unknown table 'local' in field list
117
SET global.query_cache_limit = 1;
118
ERROR 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_limit = 1' at line 1
119
SELECT global.query_cache_limit;
120
ERROR 42S02: Unknown table 'global' in field list
121
SELECT query_cache_limit = @@session.query_cache_limit;
122
ERROR 42S22: Unknown column 'query_cache_limit' in 'field list'
123
SET @@global.query_cache_limit = @start_value;
124
SELECT @@global.query_cache_limit;
125
@@global.query_cache_limit