Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.block_encryption_mode;
2 SELECT @start_global_value;
3 @start_global_value
4 aes-128-ecb
5 SET @start_session_value = @@session.block_encryption_mode;
6 SELECT @start_session_value;
7 @start_session_value
8 aes-128-ecb
9 '#--------------------FN_DYNVARS_002_01-------------------------#'
10 SET @@global.block_encryption_mode = 'aes-192-ecb';
11 SET @@global.block_encryption_mode = DEFAULT;
12 SELECT @@global.block_encryption_mode;
13 @@global.block_encryption_mode
14 aes-128-ecb
15 SET @@session.block_encryption_mode = 'aes-192-ecb';
16 SET @@session.block_encryption_mode = DEFAULT;
17 SELECT @@session.block_encryption_mode;
18 @@session.block_encryption_mode
19 aes-128-ecb
20 '#--------------------FN_DYNVARS_002_02-------------------------#'
21 SET @@global.block_encryption_mode = @start_global_value;
22 SELECT @@global.block_encryption_mode = 'aes-128-ecb';
23 @@global.block_encryption_mode = 'aes-128-ecb'
24 1
25 SET @@session.block_encryption_mode = @start_session_value;
26 SELECT @@session.block_encryption_mode = 'aes-128-ecb';
27 @@session.block_encryption_mode = 'aes-128-ecb'
28 1
29 '#--------------------FN_DYNVARS_002_03-------------------------#'
30 SET @@global.block_encryption_mode = 'aes-128-ecb';
31 SELECT @@global.block_encryption_mode;
32 @@global.block_encryption_mode
33 aes-128-ecb
34 SET @@global.block_encryption_mode = 'aes-256-ecb';
35 SELECT @@global.block_encryption_mode;
36 @@global.block_encryption_mode
37 aes-256-ecb
38 SET @@global.block_encryption_mode = 'aes-256-cbc';
39 SELECT @@global.block_encryption_mode;
40 @@global.block_encryption_mode
41 aes-256-cbc
42 '#--------------------FN_DYNVARS_002_04-------------------------#'
43 SET @@session.block_encryption_mode = 'aes-128-ecb';
44 SELECT @@session.block_encryption_mode;
45 @@session.block_encryption_mode
46 aes-128-ecb
47 SET @@session.block_encryption_mode = 'aes-256-ecb';
48 SELECT @@session.block_encryption_mode;
49 @@session.block_encryption_mode
50 aes-256-ecb
51 SET @@session.block_encryption_mode = 'aes-256-cbc';
52 SELECT @@session.block_encryption_mode;
53 @@session.block_encryption_mode
54 aes-256-cbc
55 '#------------------FN_DYNVARS_002_05-----------------------#'
56 SET @@global.block_encryption_mode = 0;
57 SELECT @@global.block_encryption_mode;
58 @@global.block_encryption_mode
59 aes-128-ecb
60 SET @@global.block_encryption_mode = -1024;
61 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '-1024'
62 SELECT @@global.block_encryption_mode;
63 @@global.block_encryption_mode
64 aes-128-ecb
65 SET @@global.block_encryption_mode = 65536;
66 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '65536'
67 SELECT @@global.block_encryption_mode;
68 @@global.block_encryption_mode
69 aes-128-ecb
70 SET @@global.block_encryption_mode = 4294967295;
71 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '4294967295'
72 SELECT @@global.block_encryption_mode;
73 @@global.block_encryption_mode
74 aes-128-ecb
75 SET @@global.block_encryption_mode = 65535.4;
76 ERROR 42000: Incorrect argument type to variable 'block_encryption_mode'
77 SELECT @@global.block_encryption_mode;
78 @@global.block_encryption_mode
79 aes-128-ecb
80 SET @@global.block_encryption_mode = ON;
81 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'ON'
82 SELECT @@global.block_encryption_mode;
83 @@global.block_encryption_mode
84 aes-128-ecb
85 SET @@global.block_encryption_mode = OFF;
86 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'OFF'
87 SELECT @@global.block_encryption_mode;
88 @@global.block_encryption_mode
89 aes-128-ecb
90 SET @@global.block_encryption_mode = test;
91 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'test'
92 SELECT @@global.block_encryption_mode;
93 @@global.block_encryption_mode
94 aes-128-ecb
95 SET @@global.block_encryption_mode = 'des-128-ecb';
96 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'des-128-ecb'
97 SELECT @@global.block_encryption_mode;
98 @@global.block_encryption_mode
99 aes-128-ecb
100 SET @@session.block_encryption_mode = 0;
101 SELECT @@session.block_encryption_mode;
102 @@session.block_encryption_mode
103 aes-128-ecb
104 SET @@session.block_encryption_mode = -1024;
105 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '-1024'
106 SELECT @@session.block_encryption_mode;
107 @@session.block_encryption_mode
108 aes-128-ecb
109 SET @@session.block_encryption_mode = 65536;
110 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '65536'
111 SELECT @@session.block_encryption_mode;
112 @@session.block_encryption_mode
113 aes-128-ecb
114 SET @@session.block_encryption_mode = 4294967295;
115 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of '4294967295'
116 SELECT @@session.block_encryption_mode;
117 @@session.block_encryption_mode
118 aes-128-ecb
119 SET @@session.block_encryption_mode = 65535.4;
120 ERROR 42000: Incorrect argument type to variable 'block_encryption_mode'
121 SELECT @@session.block_encryption_mode;
122 @@session.block_encryption_mode
123 aes-128-ecb
124 SET @@session.block_encryption_mode = ON;
125 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'ON'
126 SELECT @@session.block_encryption_mode;
127 @@session.block_encryption_mode
128 aes-128-ecb
129 SET @@session.block_encryption_mode = OFF;
130 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'OFF'
131 SELECT @@session.block_encryption_mode;
132 @@session.block_encryption_mode
133 aes-128-ecb
134 SET @@session.block_encryption_mode = test;
135 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'test'
136 SELECT @@session.block_encryption_mode;
137 @@session.block_encryption_mode
138 aes-128-ecb
139 SET @@session.block_encryption_mode = 'des-128-ecb';
140 ERROR 42000: Variable 'block_encryption_mode' can't be set to the value of 'des-128-ecb'
141 SELECT @@session.block_encryption_mode;
142 @@session.block_encryption_mode
143 aes-128-ecb
144 '#------------------FN_DYNVARS_002_06-----------------------#'
145 SELECT @@global.block_encryption_mode = VARIABLE_VALUE
146 FROM performance_schema.global_variables
147 WHERE VARIABLE_NAME='block_encryption_mode';
148 @@global.block_encryption_mode = VARIABLE_VALUE
149 1
150 '#------------------FN_DYNVARS_002_07-----------------------#'
151 SELECT @@session.block_encryption_mode = VARIABLE_VALUE
152 FROM performance_schema.session_variables
153 WHERE VARIABLE_NAME='block_encryption_mode';
154 @@session.block_encryption_mode = VARIABLE_VALUE
155 1
156 '#------------------FN_DYNVARS_002_08-----------------------#'
157 SET @@global.block_encryption_mode = TRUE;
158 SELECT @@global.block_encryption_mode;
159 @@global.block_encryption_mode
160 aes-192-ecb
161 SET @@global.block_encryption_mode = FALSE;
162 SELECT @@global.block_encryption_mode;
163 @@global.block_encryption_mode
164 aes-128-ecb
165 '#---------------------FN_DYNVARS_001_09----------------------#'
166 SET @@global.block_encryption_mode = 'aes-192-ecb';
167 SET @@session.block_encryption_mode = 'aes-256-cbc';
168 SELECT @@block_encryption_mode = @@global.block_encryption_mode;
169 @@block_encryption_mode = @@global.block_encryption_mode
170 0
171 '#---------------------FN_DYNVARS_001_10----------------------#'
172 SET @@block_encryption_mode = 'aes-192-cbc';
173 SELECT @@block_encryption_mode = @@local.block_encryption_mode;
174 @@block_encryption_mode = @@local.block_encryption_mode
175 1
176 SELECT @@local.block_encryption_mode = @@session.block_encryption_mode;
177 @@local.block_encryption_mode = @@session.block_encryption_mode
178 1
179 '#---------------------FN_DYNVARS_001_11----------------------#'
180 SET block_encryption_mode = 'aes-128-cbc';
181 SELECT @@block_encryption_mode;
182 @@block_encryption_mode
183 aes-128-cbc
184 SELECT local.block_encryption_mode;
185 ERROR 42S02: Unknown table 'local' in field list
186 SELECT session.block_encryption_mode;
187 ERROR 42S02: Unknown table 'session' in field list
188 SELECT block_encryption_mode = @@session.block_encryption_mode;
189 ERROR 42S22: Unknown column 'block_encryption_mode' in 'field list'
190 SET @@global.block_encryption_mode = @start_global_value;
191 SELECT @@global.block_encryption_mode;
192 @@global.block_encryption_mode
193 aes-128-ecb
194 SET @@session.block_encryption_mode = @start_session_value;
195 SELECT @@session.block_encryption_mode;
196 @@session.block_encryption_mode
197 aes-128-ecb
198 #
199 # End of 5.7 tests
200 #