Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_immediate_scrub_data_uncompressed;
2 #
3 # exists as global only
4 #
5 select @@global.innodb_immediate_scrub_data_uncompressed;
6 @@global.innodb_immediate_scrub_data_uncompressed
7 0
8 select @@session.innodb_immediate_scrub_data_uncompressed;
9 ERROR HY000: Variable 'innodb_immediate_scrub_data_uncompressed' is a GLOBAL variable
10 show global variables like 'innodb_immediate_scrub_data_uncompressed';
11 Variable_name Value
12 innodb_immediate_scrub_data_uncompressed OFF
13 show session variables like 'innodb_immediate_scrub_data_uncompressed';
14 Variable_name Value
15 innodb_immediate_scrub_data_uncompressed OFF
16 select * from information_schema.global_variables
17 where variable_name='innodb_immediate_scrub_data_uncompressed';
18 VARIABLE_NAME VARIABLE_VALUE
19 INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED OFF
20 select * from information_schema.session_variables
21 where variable_name='innodb_immediate_scrub_data_uncompressed';
22 VARIABLE_NAME VARIABLE_VALUE
23 INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED OFF
24 #
25 # show that it's writable
26 #
27 set global innodb_immediate_scrub_data_uncompressed=ON;
28 select @@global.innodb_immediate_scrub_data_uncompressed;
29 @@global.innodb_immediate_scrub_data_uncompressed
30 1
31 set global innodb_immediate_scrub_data_uncompressed=OFF;
32 select @@global.innodb_immediate_scrub_data_uncompressed;
33 @@global.innodb_immediate_scrub_data_uncompressed
34 0
35 set global innodb_immediate_scrub_data_uncompressed=1;
36 select @@global.innodb_immediate_scrub_data_uncompressed;
37 @@global.innodb_immediate_scrub_data_uncompressed
38 1
39 set session innodb_immediate_scrub_data_uncompressed=1;
40 ERROR HY000: Variable 'innodb_immediate_scrub_data_uncompressed' is a GLOBAL variable and should be set with SET GLOBAL
41 #
42 # incorrect types
43 #
44 set global innodb_immediate_scrub_data_uncompressed=1.1;
45 ERROR 42000: Incorrect argument type to variable 'innodb_immediate_scrub_data_uncompressed'
46 set global innodb_immediate_scrub_data_uncompressed=1e1;
47 ERROR 42000: Incorrect argument type to variable 'innodb_immediate_scrub_data_uncompressed'
48 set global innodb_immediate_scrub_data_uncompressed="foo";
49 ERROR 42000: Variable 'innodb_immediate_scrub_data_uncompressed' can't be set to the value of 'foo'
50 SET @@global.innodb_immediate_scrub_data_uncompressed = @start_global_value;