Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.innodb_encrypt_log;
2 @@GLOBAL.innodb_encrypt_log
3 0
4 0 Expected
5 SET @@GLOBAL.innodb_encrypt_log=1;
6 ERROR HY000: Variable 'innodb_encrypt_log' is a read only variable
7 Expected error 'Read only variable'
8 SELECT @@GLOBAL.innodb_encrypt_log;
9 @@GLOBAL.innodb_encrypt_log
10 0
11 0 Expected
12 SELECT IF(@@GLOBAL.innodb_encrypt_log, 'ON', 'OFF') = VARIABLE_VALUE
13 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
14 WHERE VARIABLE_NAME='innodb_encrypt_log';
15 IF(@@GLOBAL.innodb_encrypt_log, 'ON', 'OFF') = VARIABLE_VALUE
16 1
17 1 Expected
18 SELECT @@GLOBAL.innodb_encrypt_log;
19 @@GLOBAL.innodb_encrypt_log
20 0
21 0 Expected
22 SELECT VARIABLE_VALUE
23 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
24 WHERE VARIABLE_NAME='innodb_encrypt_log';
25 VARIABLE_VALUE
26 OFF
27 0 Expected
28 SELECT @@innodb_encrypt_log = @@GLOBAL.innodb_encrypt_log;
29 @@innodb_encrypt_log = @@GLOBAL.innodb_encrypt_log
30 1
31 1 Expected
32 SELECT @@innodb_encrypt_log;
33 @@innodb_encrypt_log
34 0
35 0 Expected
36 SELECT COUNT(@@local.innodb_encrypt_log);
37 ERROR HY000: Variable 'innodb_encrypt_log' is a GLOBAL variable
38 Expected error 'Variable is a GLOBAL variable'
39 SELECT COUNT(@@SESSION.innodb_encrypt_log);
40 ERROR HY000: Variable 'innodb_encrypt_log' is a GLOBAL variable
41 Expected error 'Variable is a GLOBAL variable'
42 SELECT @@GLOBAL.innodb_encrypt_log;
43 @@GLOBAL.innodb_encrypt_log
44 0
45 0 Expected
46 SELECT innodb_encrypt_log;
47 ERROR 42S22: Unknown column 'innodb_encrypt_log' in 'SELECT'
48 Expected error 'Unknown column in field list'