Debian Codegraph @

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

raw
1 # Check the default value
2 SET @orig = @@global.innodb_log_writer_threads;
3
4 SET GLOBAL innodb_log_writer_threads = OFF;
5 SELECT @@global.innodb_log_writer_threads;
6
7 SET GLOBAL innodb_log_writer_threads = default;
8 SELECT @@global.innodb_log_writer_threads;
9
10 SET GLOBAL innodb_log_writer_threads = ON;
11 SELECT @@global.innodb_log_writer_threads;
12
13 -- error ER_WRONG_VALUE_FOR_VAR
14 SET GLOBAL innodb_log_writer_threads = 2;
15 SELECT @@global.innodb_log_writer_threads;
16
17 -- error ER_WRONG_TYPE_FOR_VAR
18 SET GLOBAL innodb_log_writer_threads = 1e2;
19 SELECT @@global.innodb_log_writer_threads;
20
21 -- error ER_WRONG_TYPE_FOR_VAR
22 SET GLOBAL innodb_log_writer_threads = 1.0;
23 SELECT @@global.innodb_log_writer_threads;
24
25 -- error ER_GLOBAL_VARIABLE
26 SET innodb_log_writer_threads = OFF;
27 SELECT @@global.innodb_log_writer_threads;
28
29 SET GLOBAL innodb_log_writer_threads = @orig;