Debian Codegraph @

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

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