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