Debian Codegraph @

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

raw
1 SET @start_value = @@global.query_cache_limit;
2 SELECT @start_value;
3 @start_value
4 1048576
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
10 1048576
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
15 1
16 '#--------------------FN_DYNVARS_131_03------------------------#'
17 SET @@global.query_cache_limit = 0;
18 SELECT @@global.query_cache_limit;
19 @@global.query_cache_limit
20 0
21 SET @@global.query_cache_limit = 1;
22 SELECT @@global.query_cache_limit;
23 @@global.query_cache_limit
24 1
25 SET @@global.query_cache_limit = 1048576;
26 SELECT @@global.query_cache_limit;
27 @@global.query_cache_limit
28 1048576
29 SET @@global.query_cache_limit = 1048575;
30 SELECT @@global.query_cache_limit;
31 @@global.query_cache_limit
32 1048575
33 '#--------------------FN_DYNVARS_131_04-------------------------#'
34 SET @@global.query_cache_limit = -1;
35 Warnings:
36 Warning 1292 Truncated incorrect query_cache_limit value: '-1'
37 SELECT @@global.query_cache_limit;
38 @@global.query_cache_limit
39 0
40 SET @@global.query_cache_limit = 4294967296;
41 Warnings:
42 Warning 1292 Truncated incorrect query_cache_limit value: '4294967296'
43 SELECT @@global.query_cache_limit;
44 @@global.query_cache_limit
45 4294967295
46 SET @@global.query_cache_limit = 10240022115;
47 Warnings:
48 Warning 1292 Truncated incorrect query_cache_limit value: '10240022115'
49 SELECT @@global.query_cache_limit;
50 @@global.query_cache_limit
51 4294967295
52 SET @@global.query_cache_limit = 10000.01;
53 ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
54 SELECT @@global.query_cache_limit;
55 @@global.query_cache_limit
56 4294967295
57 SET @@global.query_cache_limit = -1024;
58 Warnings:
59 Warning 1292 Truncated incorrect query_cache_limit value: '-1024'
60 SELECT @@global.query_cache_limit;
61 @@global.query_cache_limit
62 0
63 SET @@global.query_cache_limit = 42949672950;
64 Warnings:
65 Warning 1292 Truncated incorrect query_cache_limit value: '42949672950'
66 SELECT @@global.query_cache_limit;
67 @@global.query_cache_limit
68 4294967295
69 SET @@global.query_cache_limit = ON;
70 ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
71 SELECT @@global.query_cache_limit;
72 @@global.query_cache_limit
73 4294967295
74 SET @@global.query_cache_limit = 'test';
75 ERROR 42000: Incorrect argument type to variable 'query_cache_limit'
76 SELECT @@global.query_cache_limit;
77 @@global.query_cache_limit
78 4294967295
79 '#-------------------FN_DYNVARS_131_05----------------------------#'
80 SET @@session.query_cache_limit = 0;
81 ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL
82 SELECT @@query_cache_limit;
83 @@query_cache_limit
84 4294967295
85 '#----------------------FN_DYNVARS_131_06------------------------#'
86 SELECT @@global.query_cache_limit = VARIABLE_VALUE
87 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
88 WHERE VARIABLE_NAME='query_cache_limit';
89 @@global.query_cache_limit = VARIABLE_VALUE
90 1
91 SELECT @@query_cache_limit = VARIABLE_VALUE
92 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
93 WHERE VARIABLE_NAME='query_cache_limit';
94 @@query_cache_limit = VARIABLE_VALUE
95 1
96 '#---------------------FN_DYNVARS_131_07----------------------#'
97 SET @@global.query_cache_limit = TRUE;
98 SELECT @@global.query_cache_limit;
99 @@global.query_cache_limit
100 1
101 SET @@global.query_cache_limit = FALSE;
102 SELECT @@global.query_cache_limit;
103 @@global.query_cache_limit
104 0
105 '#---------------------FN_DYNVARS_131_08----------------------#'
106 SET @@global.query_cache_limit = 1;
107 SELECT @@query_cache_limit = @@global.query_cache_limit;
108 @@query_cache_limit = @@global.query_cache_limit
109 1
110 '#---------------------FN_DYNVARS_131_09----------------------#'
111 SET query_cache_limit = 1;
112 ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL
113 SELECT @@query_cache_limit;
114 @@query_cache_limit
115 1
116 SELECT local.query_cache_limit;
117 ERROR 42S02: Unknown table 'local' in SELECT
118 SELECT global.query_cache_limit;
119 ERROR 42S02: Unknown table 'global' in SELECT
120 SELECT query_cache_limit = @@session.query_cache_limit;
121 ERROR 42S22: Unknown column 'query_cache_limit' in 'SELECT'
122 SET @@global.query_cache_limit = @start_value;
123 SELECT @@global.query_cache_limit;
124 @@global.query_cache_limit
125 1048576