Debian Codegraph @

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

raw
1 SET @start_value = @@global.table_open_cache ;
2 SELECT IF(@@open_files_limit < 5000, 4000, @start_value);
3 IF(@@open_files_limit < 5000, 4000, @start_value)
4 4000
5 '#--------------------FN_DYNVARS_001_01------------------------#'
6 SET @@global.table_open_cache = 99;
7 SET @@global.table_open_cache = DeFAULT;
8 SELECT @@global.table_open_cache;
9 @@global.table_open_cache
10 4000
11 '#---------------------FN_DYNVARS_001_02-------------------------#'
12 SET @@global.table_open_cache = Default;
13 SELECT IF(@@open_files_limit < 5000, 4000, @@global.table_open_cache) = 4000;
14 IF(@@open_files_limit < 5000, 4000, @@global.table_open_cache) = 4000
15 1
16 '#--------------------FN_DYNVARS_001_03------------------------#'
17 SET @@global.table_open_cache = 8;
18 SELECT @@global.table_open_cache ;
19 @@global.table_open_cache
20 8
21 SET @@global.table_open_cache = 1;
22 SELECT @@global.table_open_cache ;
23 @@global.table_open_cache
24 1
25 SET @@global.table_open_cache = 524288;
26 SELECT @@global.table_open_cache ;
27 @@global.table_open_cache
28 524288
29 SET @@global.table_open_cache = 18000;
30 SELECT @@global.table_open_cache ;
31 @@global.table_open_cache
32 18000
33 SET @@global.table_open_cache = 65535;
34 SELECT @@global.table_open_cache ;
35 @@global.table_open_cache
36 65535
37 '#--------------------FN_DYNVARS_001_04-------------------------#'
38 SET @@global.table_open_cache = -1;
39 Warnings:
40 Warning 1292 Truncated incorrect table_open_cache value: '-1'
41 SELECT @@global.table_open_cache ;
42 @@global.table_open_cache
43 1
44 SET @@global.table_open_cache = 524289;
45 Warnings:
46 Warning 1292 Truncated incorrect table_open_cache value: '524289'
47 SELECT @@global.table_open_cache ;
48 @@global.table_open_cache
49 524288
50 SET @@global.table_open_cache = 100000000000;
51 Warnings:
52 Warning 1292 Truncated incorrect table_open_cache value: '100000000000'
53 SELECT @@global.table_open_cache ;
54 @@global.table_open_cache
55 524288
56 SET @@global.table_open_cache = -1024;
57 Warnings:
58 Warning 1292 Truncated incorrect table_open_cache value: '-1024'
59 SELECT @@global.table_open_cache ;
60 @@global.table_open_cache
61 1
62 SET @@global.table_open_cache = 0;
63 Warnings:
64 Warning 1292 Truncated incorrect table_open_cache value: '0'
65 SELECT @@global.table_open_cache ;
66 @@global.table_open_cache
67 1
68 SET @@global.table_open_cache = 10000.01;
69 ERROR 42000: Incorrect argument type to variable 'table_open_cache'
70 SET @@global.table_open_cache = ON;
71 ERROR 42000: Incorrect argument type to variable 'table_open_cache'
72 SET @@global.table_open_cache= 'test';
73 ERROR 42000: Incorrect argument type to variable 'table_open_cache'
74 SET @@global.table_open_cache = '';
75 ERROR 42000: Incorrect argument type to variable 'table_open_cache'
76 '#-------------------FN_DYNVARS_001_05----------------------------#'
77 SET @@session.table_open_cache = 0;
78 ERROR HY000: Variable 'table_open_cache' is a GLOBAL variable and should be set with SET GLOBAL
79 '#----------------------FN_DYNVARS_001_06------------------------#'
80 SELECT @@global.table_open_cache = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='table_open_cache';
81 @@global.table_open_cache = VARIABLE_VALUE
82 1
83 '#---------------------FN_DYNVARS_001_09----------------------#'
84 SET @@global.table_open_cache = TRUE;
85 SELECT @@global.table_open_cache ;
86 @@global.table_open_cache
87 1
88 SET @@global.table_open_cache = FALSE;
89 Warnings:
90 Warning 1292 Truncated incorrect table_open_cache value: '0'
91 SELECT @@global.table_open_cache ;
92 @@global.table_open_cache
93 1
94 '#---------------------FN_DYNVARS_001_10----------------------#'
95 SET @@global.table_open_cache = 10;
96 SELECT @@table_open_cache = @@global.table_open_cache ;
97 @@table_open_cache = @@global.table_open_cache
98 1
99 '#---------------------FN_DYNVARS_001_11----------------------#'
100 SET table_open_cache = 8;
101 ERROR HY000: Variable 'table_open_cache' is a GLOBAL variable and should be set with SET GLOBAL
102 SET global.table_open_cache = 10;
103 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 'global.table_open_cache = 10' at line 1
104 SELECT global.table_open_cache ;
105 ERROR 42S02: Unknown table 'global' in field list
106 SELECT table_open_cache;
107 ERROR 42S22: Unknown column 'table_open_cache' in 'field list'
108 SELECT @@session.table_open_cache ;
109 ERROR HY000: Variable 'table_open_cache' is a GLOBAL variable
110 SET @@global.table_open_cache = @start_value;
111 SELECT IF(@@open_files_limit < 5000, 4000, @start_value);
112 IF(@@open_files_limit < 5000, 4000, @start_value)
113 4000