Debian Codegraph @

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

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