1SELECT @@GLOBAL.innodb_encrypt_log;
2@@GLOBAL.innodb_encrypt_log
30
40 Expected
5SET @@GLOBAL.innodb_encrypt_log=1;
6ERROR HY000: Variable 'innodb_encrypt_log' is a read only variable
7Expected error 'Read only variable'
8SELECT @@GLOBAL.innodb_encrypt_log;
9@@GLOBAL.innodb_encrypt_log
100
110 Expected
12SELECT IF(@@GLOBAL.innodb_encrypt_log, 'ON', 'OFF') = VARIABLE_VALUE
13FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
14WHERE VARIABLE_NAME='innodb_encrypt_log';
15IF(@@GLOBAL.innodb_encrypt_log, 'ON', 'OFF') = VARIABLE_VALUE
161
171 Expected
18SELECT @@GLOBAL.innodb_encrypt_log;
19@@GLOBAL.innodb_encrypt_log
200
210 Expected
22SELECT VARIABLE_VALUE
23FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
24WHERE VARIABLE_NAME='innodb_encrypt_log';
25VARIABLE_VALUE
26OFF
270 Expected
28SELECT @@innodb_encrypt_log = @@GLOBAL.innodb_encrypt_log;
29@@innodb_encrypt_log = @@GLOBAL.innodb_encrypt_log
301
311 Expected
32SELECT @@innodb_encrypt_log;
33@@innodb_encrypt_log
340
350 Expected
36SELECT COUNT(@@local.innodb_encrypt_log);
37ERROR HY000: Variable 'innodb_encrypt_log' is a GLOBAL variable
38Expected error 'Variable is a GLOBAL variable'
39SELECT COUNT(@@SESSION.innodb_encrypt_log);
40ERROR HY000: Variable 'innodb_encrypt_log' is a GLOBAL variable
41Expected error 'Variable is a GLOBAL variable'
42SELECT @@GLOBAL.innodb_encrypt_log;
43@@GLOBAL.innodb_encrypt_log
440
450 Expected
46SELECT innodb_encrypt_log;
47ERROR 42S22: Unknown column 'innodb_encrypt_log' in 'field list'
48Expected error 'Unknown column in field list'
49