Debian Codegraph @

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

raw
1 # bool readonly
2
3 --source include/have_aria_used_for_temp_tables.inc
4 --source include/have_maria.inc
5 #
6 # show the global and session values;
7 #
8 select @@global.aria_used_for_temp_tables;
9 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
10 select @@session.aria_used_for_temp_tables;
11 show global variables like 'aria_used_for_temp_tables';
12 show session variables like 'aria_used_for_temp_tables';
13 select * from information_schema.global_variables where variable_name='aria_used_for_temp_tables';
14 select * from information_schema.session_variables where variable_name='aria_used_for_temp_tables';
15
16 #
17 # show that it's read-only
18 #
19 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 set global aria_used_for_temp_tables=1;
21 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
22 set session aria_used_for_temp_tables=1;
23