Debian Codegraph @

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

raw
1 '#---------------------BS_STVARS_015_01----------------------#'
2 SELECT COUNT(@@GLOBAL.have_query_cache);
3 COUNT(@@GLOBAL.have_query_cache)
4 1
5 Warnings:
6 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
7 1 Expected
8 '#---------------------BS_STVARS_015_02----------------------#'
9 SET @@GLOBAL.have_query_cache=1;
10 ERROR HY000: Variable 'have_query_cache' is a read only variable
11 Expected error 'Read only variable'
12 SELECT COUNT(@@GLOBAL.have_query_cache);
13 COUNT(@@GLOBAL.have_query_cache)
14 1
15 Warnings:
16 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
17 1 Expected
18 '#---------------------BS_STVARS_015_03----------------------#'
19 SELECT @@GLOBAL.have_query_cache = VARIABLE_VALUE
20 FROM performance_schema.global_variables
21 WHERE VARIABLE_NAME='have_query_cache';
22 @@GLOBAL.have_query_cache = VARIABLE_VALUE
23 1
24 1 Expected
25 SELECT COUNT(@@GLOBAL.have_query_cache);
26 COUNT(@@GLOBAL.have_query_cache)
27 1
28 Warnings:
29 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
30 1 Expected
31 SELECT COUNT(VARIABLE_VALUE)
32 FROM performance_schema.global_variables
33 WHERE VARIABLE_NAME='have_query_cache';
34 COUNT(VARIABLE_VALUE)
35 1
36 1 Expected
37 '#---------------------BS_STVARS_015_04----------------------#'
38 SELECT @@have_query_cache = @@GLOBAL.have_query_cache;
39 @@have_query_cache = @@GLOBAL.have_query_cache
40 1
41 Warnings:
42 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
43 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
44 1 Expected
45 '#---------------------BS_STVARS_015_05----------------------#'
46 SELECT COUNT(@@have_query_cache);
47 COUNT(@@have_query_cache)
48 1
49 Warnings:
50 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
51 1 Expected
52 SELECT COUNT(@@local.have_query_cache);
53 ERROR HY000: Variable 'have_query_cache' is a GLOBAL variable
54 Expected error 'Variable is a GLOBAL variable'
55 SELECT COUNT(@@SESSION.have_query_cache);
56 ERROR HY000: Variable 'have_query_cache' is a GLOBAL variable
57 Expected error 'Variable is a GLOBAL variable'
58 SELECT COUNT(@@GLOBAL.have_query_cache);
59 COUNT(@@GLOBAL.have_query_cache)
60 1
61 Warnings:
62 Warning 1287 '@@have_query_cache' is deprecated and will be removed in a future release.
63 1 Expected
64 SELECT have_query_cache;
65 ERROR 42S22: Unknown column 'have_query_cache' in 'field list'
66 Expected error 'Unknown column'