Debian Codegraph @

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

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