Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 SET @start_global_value = @@global.innodb_trx_rseg_n_slots_debug;
4 SELECT @start_global_value;
5
6 #
7 # exists as global only
8 #
9 select @@global.innodb_trx_rseg_n_slots_debug between 0 and 1024;
10 select @@global.innodb_trx_rseg_n_slots_debug;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_trx_rseg_n_slots_debug;
13 show global variables like 'innodb_trx_rseg_n_slots_debug';
14 show session variables like 'innodb_trx_rseg_n_slots_debug';
15 --disable_warnings
16 select * from performance_schema.global_variables where variable_name='innodb_trx_rseg_n_slots_debug';
17 select * from performance_schema.session_variables where variable_name='innodb_trx_rseg_n_slots_debug';
18 --enable_warnings
19
20 #
21 # show that it's writable
22 #
23 set global innodb_trx_rseg_n_slots_debug=1;
24 select @@global.innodb_trx_rseg_n_slots_debug;
25 --disable_warnings
26 select * from performance_schema.global_variables where variable_name='innodb_trx_rseg_n_slots_debug';
27 select * from performance_schema.session_variables where variable_name='innodb_trx_rseg_n_slots_debug';
28 --enable_warnings
29 set @@global.innodb_trx_rseg_n_slots_debug=0;
30 select @@global.innodb_trx_rseg_n_slots_debug;
31 --disable_warnings
32 select * from performance_schema.global_variables where variable_name='innodb_trx_rseg_n_slots_debug';
33 select * from performance_schema.session_variables where variable_name='innodb_trx_rseg_n_slots_debug';
34 --enable_warnings
35 --error ER_GLOBAL_VARIABLE
36 set session innodb_trx_rseg_n_slots_debug='some';
37 --error ER_GLOBAL_VARIABLE
38 set @@session.innodb_trx_rseg_n_slots_debug='some';
39
40 #
41 # incorrect types
42 #
43 --error ER_WRONG_TYPE_FOR_VAR
44 set global innodb_trx_rseg_n_slots_debug=1.1;
45 --error ER_WRONG_TYPE_FOR_VAR
46 set global innodb_trx_rseg_n_slots_debug='foo';
47 set global innodb_trx_rseg_n_slots_debug=-2;
48 --error ER_WRONG_TYPE_FOR_VAR
49 set global innodb_trx_rseg_n_slots_debug=1e1;
50 set global innodb_trx_rseg_n_slots_debug=1024;
51 set global innodb_trx_rseg_n_slots_debug=1025;
52
53 #
54 # Cleanup
55 #
56
57 SET @@global.innodb_trx_rseg_n_slots_debug = @start_global_value;
58 SELECT @@global.innodb_trx_rseg_n_slots_debug;