1SET @start_global_value = @@global.aria_page_checksum;
2select @@global.aria_page_checksum;
3@@global.aria_page_checksum
41
5select @@session.aria_page_checksum;
6ERROR HY000: Variable 'aria_page_checksum' is a GLOBAL variable
7show global variables like 'aria_page_checksum';
8Variable_name	Value
9aria_page_checksum	ON
10show session variables like 'aria_page_checksum';
11Variable_name	Value
12aria_page_checksum	ON
13select * from information_schema.global_variables where variable_name='aria_page_checksum';
14VARIABLE_NAME	VARIABLE_VALUE
15ARIA_PAGE_CHECKSUM	ON
16select * from information_schema.session_variables where variable_name='aria_page_checksum';
17VARIABLE_NAME	VARIABLE_VALUE
18ARIA_PAGE_CHECKSUM	ON
19set global aria_page_checksum=ON;
20select @@global.aria_page_checksum;
21@@global.aria_page_checksum
221
23set global aria_page_checksum=OFF;
24select @@global.aria_page_checksum;
25@@global.aria_page_checksum
260
27set global aria_page_checksum=1;
28select @@global.aria_page_checksum;
29@@global.aria_page_checksum
301
31set session aria_page_checksum=1;
32ERROR HY000: Variable 'aria_page_checksum' is a GLOBAL variable and should be set with SET GLOBAL
33set global aria_page_checksum=1.1;
34ERROR 42000: Incorrect argument type to variable 'aria_page_checksum'
35set global aria_page_checksum=1e1;
36ERROR 42000: Incorrect argument type to variable 'aria_page_checksum'
37set global aria_page_checksum="foo";
38ERROR 42000: Variable 'aria_page_checksum' can't be set to the value of 'foo'
39SET @@global.aria_page_checksum = @start_global_value;
40