Debian Codegraph @

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

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