Debian Codegraph @

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

raw
1 SET @start_value = @@global.query_cache_size;
2 '#--------------------FN_DYNVARS_133_01------------------------#'
3 SET @@global.query_cache_size = 99;
4 Warnings:
5 Warning 1292 Truncated incorrect query_cache_size value: '99'
6 SET @@global.query_cache_size = DEFAULT;
7 SELECT @@global.query_cache_size;
8 @@global.query_cache_size
9 1048576
10 '#---------------------FN_DYNVARS_133_02-------------------------#'
11 SET @@global.query_cache_size = @start_value;
12 SELECT @@global.query_cache_size = @start_value;
13 @@global.query_cache_size = @start_value
14 1
15 '#--------------------FN_DYNVARS_133_03------------------------#'
16 SET @@global.query_cache_size = 0;
17 SELECT @@global.query_cache_size;
18 @@global.query_cache_size
19 0
20 SET @@global.query_cache_size = 1;
21 Warnings:
22 Warning 1292 Truncated incorrect query_cache_size value: '1'
23 SELECT @@global.query_cache_size;
24 @@global.query_cache_size
25 0
26 SET @@global.query_cache_size = 512;
27 Warnings:
28 Warning 1292 Truncated incorrect query_cache_size value: '512'
29 SELECT @@global.query_cache_size;
30 @@global.query_cache_size
31 0
32 SET @@global.query_cache_size = 1024;
33 Warnings:
34 Warning 1282 Query cache failed to set size 1024; new query cache size is 0
35 SELECT @@global.query_cache_size;
36 @@global.query_cache_size
37 0
38 SET @@global.query_cache_size = 1048576;
39 SELECT @@global.query_cache_size;
40 @@global.query_cache_size
41 1048576
42 SET @@global.query_cache_size = 1048575;
43 Warnings:
44 Warning 1292 Truncated incorrect query_cache_size value: '1048575'
45 SELECT @@global.query_cache_size;
46 @@global.query_cache_size
47 1047552
48 '#--------------------FN_DYNVARS_133_04-------------------------#'
49 SET @@global.query_cache_size = -1;
50 Warnings:
51 Warning 1292 Truncated incorrect query_cache_size value: '-1'
52 SELECT @@global.query_cache_size;
53 @@global.query_cache_size
54 0
55 SET @@global.query_cache_size = 511;
56 Warnings:
57 Warning 1292 Truncated incorrect query_cache_size value: '511'
58 SELECT @@global.query_cache_size;
59 @@global.query_cache_size
60 0
61 SET @@global.query_cache_size = 10000.01;
62 ERROR 42000: Incorrect argument type to variable 'query_cache_size'
63 SELECT @@global.query_cache_size;
64 @@global.query_cache_size
65 0
66 SET @@global.query_cache_size = -1024;
67 Warnings:
68 Warning 1292 Truncated incorrect query_cache_size value: '-1024'
69 SELECT @@global.query_cache_size;
70 @@global.query_cache_size
71 0
72 SET @@global.query_cache_size = ON;
73 ERROR 42000: Incorrect argument type to variable 'query_cache_size'
74 SELECT @@global.query_cache_size;
75 @@global.query_cache_size
76 0
77 SET @@global.query_cache_size = 'test';
78 ERROR 42000: Incorrect argument type to variable 'query_cache_size'
79 SELECT @@global.query_cache_size;
80 @@global.query_cache_size
81 0
82 '#-------------------FN_DYNVARS_133_05----------------------------#'
83 SET @@session.query_cache_size = 0;
84 ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
85 SELECT @@query_cache_size;
86 @@query_cache_size
87 0
88 '#----------------------FN_DYNVARS_133_06------------------------#'
89 SELECT @@global.query_cache_size = VARIABLE_VALUE
90 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91 WHERE VARIABLE_NAME='query_cache_size';
92 @@global.query_cache_size = VARIABLE_VALUE
93 1
94 SELECT @@query_cache_size = VARIABLE_VALUE
95 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
96 WHERE VARIABLE_NAME='query_cache_size';
97 @@query_cache_size = VARIABLE_VALUE
98 1
99 '#---------------------FN_DYNVARS_133_07----------------------#'
100 SET @@global.query_cache_size = TRUE;
101 Warnings:
102 Warning 1292 Truncated incorrect query_cache_size value: '1'
103 SELECT @@global.query_cache_size;
104 @@global.query_cache_size
105 0
106 SET @@global.query_cache_size = FALSE;
107 SELECT @@global.query_cache_size;
108 @@global.query_cache_size
109 0
110 '#---------------------FN_DYNVARS_133_08----------------------#'
111 SET @@global.query_cache_size = 1;
112 Warnings:
113 Warning 1292 Truncated incorrect query_cache_size value: '1'
114 SELECT @@query_cache_size = @@global.query_cache_size;
115 @@query_cache_size = @@global.query_cache_size
116 1
117 '#---------------------FN_DYNVARS_133_09----------------------#'
118 SET query_cache_size = 1;
119 ERROR HY000: Variable 'query_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
120 SELECT @@query_cache_size;
121 @@query_cache_size
122 0
123 SELECT local.query_cache_size;
124 ERROR 42S02: Unknown table 'local' in SELECT
125 SELECT global.query_cache_size;
126 ERROR 42S02: Unknown table 'global' in SELECT
127 SELECT query_cache_size = @@session.query_cache_size;
128 ERROR 42S22: Unknown column 'query_cache_size' in 'SELECT'
129 SET @@global.query_cache_size = @start_value;