Debian Codegraph @

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

raw
1 SET @start_value = @@global.key_cache_division_limit;
2 SELECT @start_value;
3 @start_value
4 100
5 '#--------------------FN_DYNVARS_058_01------------------------#'
6 SET @@global.key_cache_division_limit = DEFAULT;
7 SELECT @@global.key_cache_division_limit;
8 @@global.key_cache_division_limit
9 100
10 '#---------------------FN_DYNVARS_058_02-------------------------#'
11 SET @@global.key_cache_division_limit = @start_value;
12 SELECT @@global.key_cache_division_limit = 100;
13 @@global.key_cache_division_limit = 100
14 1
15 '#--------------------FN_DYNVARS_058_03------------------------#'
16 SET @@global.key_cache_division_limit = 1;
17 SELECT @@global.key_cache_division_limit;
18 @@global.key_cache_division_limit
19 1
20 SET @@global.key_cache_division_limit = 50;
21 SELECT @@global.key_cache_division_limit;
22 @@global.key_cache_division_limit
23 50
24 SET @@global.key_cache_division_limit = 99;
25 SELECT @@global.key_cache_division_limit;
26 @@global.key_cache_division_limit
27 99
28 SET @@global.key_cache_division_limit = 2;
29 SELECT @@global.key_cache_division_limit;
30 @@global.key_cache_division_limit
31 2
32 '#--------------------FN_DYNVARS_058_04-------------------------#'
33 SET @@global.key_cache_division_limit = -1;
34 Warnings:
35 Warning 1292 Truncated incorrect key_cache_division_limit value: '-1'
36 SELECT @@global.key_cache_division_limit;
37 @@global.key_cache_division_limit
38 1
39 SET @@global.key_cache_division_limit = 101;
40 Warnings:
41 Warning 1292 Truncated incorrect key_cache_division_limit value: '101'
42 SELECT @@global.key_cache_division_limit;
43 @@global.key_cache_division_limit
44 100
45 SET @@global.key_cache_division_limit = 10000.01;
46 ERROR 42000: Incorrect argument type to variable 'key_cache_division_limit'
47 SELECT @@global.key_cache_division_limit;
48 @@global.key_cache_division_limit
49 100
50 SET @@global.key_cache_division_limit = -1024;
51 Warnings:
52 Warning 1292 Truncated incorrect key_cache_division_limit value: '-1024'
53 SELECT @@global.key_cache_division_limit;
54 @@global.key_cache_division_limit
55 1
56 SET @@global.key_cache_division_limit = 0;
57 Warnings:
58 Warning 1292 Truncated incorrect key_cache_division_limit value: '0'
59 SELECT @@global.key_cache_division_limit;
60 @@global.key_cache_division_limit
61 1
62 SET @@global.key_cache_division_limit = 200;
63 Warnings:
64 Warning 1292 Truncated incorrect key_cache_division_limit value: '200'
65 SELECT @@global.key_cache_division_limit;
66 @@global.key_cache_division_limit
67 100
68 SET @@global.key_cache_division_limit = 65535;
69 Warnings:
70 Warning 1292 Truncated incorrect key_cache_division_limit value: '65535'
71 SELECT @@global.key_cache_division_limit;
72 @@global.key_cache_division_limit
73 100
74 SET @@global.key_cache_division_limit = ON;
75 ERROR 42000: Incorrect argument type to variable 'key_cache_division_limit'
76 SELECT @@global.key_cache_division_limit;
77 @@global.key_cache_division_limit
78 100
79 SET @@global.key_cache_division_limit = 'test';
80 ERROR 42000: Incorrect argument type to variable 'key_cache_division_limit'
81 SELECT @@global.key_cache_division_limit;
82 @@global.key_cache_division_limit
83 100
84 '#-------------------FN_DYNVARS_058_05----------------------------#'
85 SET @@session.key_cache_division_limit = 0;
86 ERROR HY000: Variable 'key_cache_division_limit' is a GLOBAL variable and should be set with SET GLOBAL
87 SELECT @@session.key_cache_division_limit;
88 ERROR HY000: Variable 'key_cache_division_limit' is a GLOBAL variable
89 '#----------------------FN_DYNVARS_058_06------------------------#'
90 SELECT @@global.key_cache_division_limit = VARIABLE_VALUE
91 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
92 WHERE VARIABLE_NAME='key_cache_division_limit';
93 @@global.key_cache_division_limit = VARIABLE_VALUE
94 1
95 SELECT @@key_cache_division_limit = VARIABLE_VALUE
96 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
97 WHERE VARIABLE_NAME='key_cache_division_limit';
98 @@key_cache_division_limit = VARIABLE_VALUE
99 1
100 '#---------------------FN_DYNVARS_058_07----------------------#'
101 SET @@global.key_cache_division_limit = TRUE;
102 SELECT @@global.key_cache_division_limit;
103 @@global.key_cache_division_limit
104 1
105 SET @@global.key_cache_division_limit = FALSE;
106 Warnings:
107 Warning 1292 Truncated incorrect key_cache_division_limit value: '0'
108 SELECT @@global.key_cache_division_limit;
109 @@global.key_cache_division_limit
110 1
111 '#---------------------FN_DYNVARS_058_08----------------------#'
112 SET @@global.key_cache_division_limit = 90;
113 SELECT @@key_cache_division_limit = @@global.key_cache_division_limit;
114 @@key_cache_division_limit = @@global.key_cache_division_limit
115 1
116 '#---------------------FN_DYNVARS_058_09----------------------#'
117 SET key_cache_division_limit = 80;
118 ERROR HY000: Variable 'key_cache_division_limit' is a GLOBAL variable and should be set with SET GLOBAL
119 SELECT @@key_cache_division_limit;
120 @@key_cache_division_limit
121 90
122 SELECT local.key_cache_division_limit;
123 ERROR 42S02: Unknown table 'local' in SELECT
124 SELECT global.key_cache_division_limit;
125 ERROR 42S02: Unknown table 'global' in SELECT
126 SELECT key_cache_division_limit = @@session.key_cache_division_limit;
127 ERROR 42S22: Unknown column 'key_cache_division_limit' in 'SELECT'
128 SET @@global.key_cache_division_limit = @start_value;
129 SELECT @@global.key_cache_division_limit;
130 @@global.key_cache_division_limit
131 100