1
SET @start_value = @@global.table_open_cache ;
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
11
'#---------------------FN_DYNVARS_001_02-------------------------#'
12
SET @@global.table_open_cache = Default;
13
SELECT @@global.table_open_cache = 64;
14
@@global.table_open_cache = 64
16
'#--------------------FN_DYNVARS_001_03------------------------#'
17
SET @@global.table_open_cache = 8;
18
SELECT @@global.table_open_cache ;
19
@@global.table_open_cache
21
SET @@global.table_open_cache = 1;
22
SELECT @@global.table_open_cache ;
23
@@global.table_open_cache
25
SET @@global.table_open_cache = 1073741824;
27
Warning 1292 Truncated incorrect table_open_cache value: '1073741824'
28
SELECT @@global.table_open_cache ;
29
@@global.table_open_cache
31
SET @@global.table_open_cache = 18000;
32
SELECT @@global.table_open_cache ;
33
@@global.table_open_cache
35
SET @@global.table_open_cache = 65535;
36
SELECT @@global.table_open_cache ;
37
@@global.table_open_cache
39
'#--------------------FN_DYNVARS_001_04-------------------------#'
40
SET @@global.table_open_cache = -1;
42
Warning 1292 Truncated incorrect table_open_cache value: '0'
43
SELECT @@global.table_open_cache ;
44
@@global.table_open_cache
46
SET @@global.table_open_cache = 100000000000;
48
Warning 1292 Truncated incorrect table_open_cache value: '100000000000'
49
SELECT @@global.table_open_cache ;
50
@@global.table_open_cache
52
SET @@global.table_open_cache = -1024;
54
Warning 1292 Truncated incorrect table_open_cache value: '0'
55
SELECT @@global.table_open_cache ;
56
@@global.table_open_cache
58
SET @@global.table_open_cache = 0;
60
Warning 1292 Truncated incorrect table_open_cache value: '0'
61
SELECT @@global.table_open_cache ;
62
@@global.table_open_cache
64
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
65
SET @@global.table_open_cache = 10000.01;
66
ERROR 42000: Incorrect argument type to variable 'table_open_cache'
67
SET @@global.table_open_cache = ON;
68
ERROR 42000: Incorrect argument type to variable 'table_open_cache'
69
SET @@global.table_open_cache= 'test';
70
ERROR 42000: Incorrect argument type to variable 'table_open_cache'
71
SET @@global.table_open_cache = '';
72
ERROR 42000: Incorrect argument type to variable 'table_open_cache'
73
'#-------------------FN_DYNVARS_001_05----------------------------#'
74
SET @@session.table_open_cache = 0;
75
ERROR HY000: Variable 'table_open_cache' is a GLOBAL variable and should be set with SET GLOBAL
76
'#----------------------FN_DYNVARS_001_06------------------------#'
77
SELECT @@global.table_open_cache = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='table_open_cache ';
78
@@global.table_open_cache = VARIABLE_VALUE
80
'#---------------------FN_DYNVARS_001_09----------------------#'
81
SET @@global.table_open_cache = TRUE;
82
SELECT @@global.table_open_cache ;
83
@@global.table_open_cache
85
SET @@global.table_open_cache = FALSE;
87
Warning 1292 Truncated incorrect table_open_cache value: '0'
88
SELECT @@global.table_open_cache ;
89
@@global.table_open_cache
91
'#---------------------FN_DYNVARS_001_10----------------------#'
92
SET @@global.table_open_cache = 10;
93
SELECT @@table_open_cache = @@global.table_open_cache ;
94
@@table_open_cache = @@global.table_open_cache
96
'#---------------------FN_DYNVARS_001_11----------------------#'
97
SET table_open_cache = 8;
98
ERROR HY000: Variable 'table_open_cache' is a GLOBAL variable and should be set with SET GLOBAL
99
SET global.table_open_cache = 10;
100
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 'table_open_cache = 10' at line 1
101
SELECT global.table_open_cache ;
102
ERROR 42S02: Unknown table 'global' in field list
103
SELECT table_open_cache = @@session.table_open_cache ;
104
ERROR 42S22: Unknown column 'table_open_cache' in 'field list'
105
SET @@global.table_open_cache = @start_value;
106
SELECT @@global.table_open_cache ;
107
@@global.table_open_cache