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