Debian Codegraph @

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

raw
1 # ulong session
2 --source include/have_maria.inc
3
4 SET @start_global_value = @@global.aria_repair_threads;
5
6 #
7 # exists as global only
8 #
9 select @@global.aria_repair_threads;
10 select @@session.aria_repair_threads;
11 show global variables like 'aria_repair_threads';
12 show session variables like 'aria_repair_threads';
13 select * from information_schema.global_variables where variable_name='aria_repair_threads';
14 select * from information_schema.session_variables where variable_name='aria_repair_threads';
15
16 #
17 # show that it's writable
18 #
19 set global aria_repair_threads=10;
20 select @@global.aria_repair_threads;
21 set session aria_repair_threads=10;
22 select @@session.aria_repair_threads;
23
24 #
25 # incorrect types
26 #
27 --error ER_WRONG_TYPE_FOR_VAR
28 set global aria_repair_threads=1.1;
29 --error ER_WRONG_TYPE_FOR_VAR
30 set session aria_repair_threads=1e1;
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global aria_repair_threads="foo";
33
34 #
35 # min/max values, block size
36 #
37 set global aria_repair_threads=0;
38 select @@global.aria_repair_threads;
39 --disable_warnings
40 set session aria_repair_threads=cast(-1 as unsigned int);
41 --enable_warnings
42 --replace_result 4294967295 18446744073709551615
43 select @@session.aria_repair_threads;
44
45 SET @@global.aria_repair_threads = @start_global_value;
46