Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_encrypt_log_basic.test

raw
1 --source include/have_innodb.inc
2
3 # Display default value
4 SELECT @@GLOBAL.innodb_encrypt_log;
5 --echo 0 Expected
6
7 # Check if value can be set
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 SET @@GLOBAL.innodb_encrypt_log=1;
10 --echo Expected error 'Read only variable'
11
12 SELECT @@GLOBAL.innodb_encrypt_log;
13 --echo 0 Expected
14
15 # Check if the value in GLOBAL TABLE matches value in variable
16 SELECT IF(@@GLOBAL.innodb_encrypt_log, 'ON', 'OFF') = VARIABLE_VALUE
17 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
18 WHERE VARIABLE_NAME='innodb_encrypt_log';
19 --echo 1 Expected
20
21 SELECT @@GLOBAL.innodb_encrypt_log;
22 --echo 0 Expected
23
24 SELECT VARIABLE_VALUE
25 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
26 WHERE VARIABLE_NAME='innodb_encrypt_log';
27 --echo 0 Expected
28
29 # Check if accessing variable with and without GLOBAL point to same variable
30 SELECT @@innodb_encrypt_log = @@GLOBAL.innodb_encrypt_log;
31 --echo 1 Expected
32
33 # Check if innodb_encrypt_log can be accessed with and without @@ sign
34 SELECT @@innodb_encrypt_log;
35 --echo 0 Expected
36
37 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
38 SELECT COUNT(@@local.innodb_encrypt_log);
39 --echo Expected error 'Variable is a GLOBAL variable'
40
41 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
42 SELECT COUNT(@@SESSION.innodb_encrypt_log);
43 --echo Expected error 'Variable is a GLOBAL variable'
44
45 SELECT @@GLOBAL.innodb_encrypt_log;
46 --echo 0 Expected
47
48 --Error ER_BAD_FIELD_ERROR
49 SELECT innodb_encrypt_log;
50 --echo Expected error 'Unknown column in field list'