Debian Codegraph @

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

raw
1 # bool global
2 --source include/have_innodb.inc
3
4 SET @start_global_value = @@global.innodb_immediate_scrub_data_uncompressed;
5
6 --echo #
7 --echo # exists as global only
8 --echo #
9 select @@global.innodb_immediate_scrub_data_uncompressed;
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.innodb_immediate_scrub_data_uncompressed;
12 show global variables like 'innodb_immediate_scrub_data_uncompressed';
13 show session variables like 'innodb_immediate_scrub_data_uncompressed';
14 select * from information_schema.global_variables
15 where variable_name='innodb_immediate_scrub_data_uncompressed';
16 select * from information_schema.session_variables
17 where variable_name='innodb_immediate_scrub_data_uncompressed';
18
19 --echo #
20 --echo # show that it's writable
21 --echo #
22 set global innodb_immediate_scrub_data_uncompressed=ON;
23 select @@global.innodb_immediate_scrub_data_uncompressed;
24 set global innodb_immediate_scrub_data_uncompressed=OFF;
25 select @@global.innodb_immediate_scrub_data_uncompressed;
26 set global innodb_immediate_scrub_data_uncompressed=1;
27 select @@global.innodb_immediate_scrub_data_uncompressed;
28 --error ER_GLOBAL_VARIABLE
29 set session innodb_immediate_scrub_data_uncompressed=1;
30
31 --echo #
32 --echo # incorrect types
33 --echo #
34 --error ER_WRONG_TYPE_FOR_VAR
35 set global innodb_immediate_scrub_data_uncompressed=1.1;
36 --error ER_WRONG_TYPE_FOR_VAR
37 set global innodb_immediate_scrub_data_uncompressed=1e1;
38 --error ER_WRONG_VALUE_FOR_VAR
39 set global innodb_immediate_scrub_data_uncompressed="foo";
40
41 SET @@global.innodb_immediate_scrub_data_uncompressed = @start_global_value;