Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.aria_repair_threads;
2 select @@global.aria_repair_threads;
3 @@global.aria_repair_threads
4 1
5 select @@session.aria_repair_threads;
6 @@session.aria_repair_threads
7 1
8 show global variables like 'aria_repair_threads';
9 Variable_name Value
10 aria_repair_threads 1
11 show session variables like 'aria_repair_threads';
12 Variable_name Value
13 aria_repair_threads 1
14 select * from information_schema.global_variables where variable_name='aria_repair_threads';
15 VARIABLE_NAME VARIABLE_VALUE
16 ARIA_REPAIR_THREADS 1
17 select * from information_schema.session_variables where variable_name='aria_repair_threads';
18 VARIABLE_NAME VARIABLE_VALUE
19 ARIA_REPAIR_THREADS 1
20 set global aria_repair_threads=10;
21 select @@global.aria_repair_threads;
22 @@global.aria_repair_threads
23 10
24 set session aria_repair_threads=10;
25 select @@session.aria_repair_threads;
26 @@session.aria_repair_threads
27 10
28 set global aria_repair_threads=1.1;
29 ERROR 42000: Incorrect argument type to variable 'aria_repair_threads'
30 set session aria_repair_threads=1e1;
31 ERROR 42000: Incorrect argument type to variable 'aria_repair_threads'
32 set global aria_repair_threads="foo";
33 ERROR 42000: Incorrect argument type to variable 'aria_repair_threads'
34 set global aria_repair_threads=0;
35 Warnings:
36 Warning 1292 Truncated incorrect aria_repair_threads value: '0'
37 select @@global.aria_repair_threads;
38 @@global.aria_repair_threads
39 1
40 set session aria_repair_threads=cast(-1 as unsigned int);
41 select @@session.aria_repair_threads;
42 @@session.aria_repair_threads
43 128
44 SET @@global.aria_repair_threads = @start_global_value;