Debian Codegraph @

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

raw
1 # Variable name: innodb_purge_threads
2 # Scope: Global
3 # Access type: Static
4 # Data type: numeric
5
6 --source include/have_innodb.inc
7
8 SELECT COUNT(@@GLOBAL.innodb_purge_threads);
9 --echo 1 Expected
10
11 SELECT COUNT(@@innodb_purge_threads);
12 --echo 1 Expected
13
14 SET @save_threads = @@GLOBAL.innodb_purge_threads;
15
16 SET @@GLOBAL.innodb_purge_threads=-1;
17 SELECT @@GLOBAL.innodb_purge_threads;
18 SET @@GLOBAL.innodb_purge_threads=0;
19 SELECT @@GLOBAL.innodb_purge_threads;
20 SET @@GLOBAL.innodb_purge_threads=33;
21 SELECT @@GLOBAL.innodb_purge_threads;
22
23 SET @@GLOBAL.innodb_purge_threads=1;
24 SET @@GLOBAL.innodb_purge_threads=32;
25
26 --Error ER_BAD_FIELD_ERROR
27 SELECT innodb_purge_threads = @@SESSION.innodb_purge_threads;
28 --echo Expected error 'Read-only variable'
29
30 --disable_warnings
31 SELECT @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE
32 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
33 WHERE VARIABLE_NAME='innodb_purge_threads';
34 --enable_warnings
35 --echo 1 Expected
36
37 --disable_warnings
38 SELECT COUNT(VARIABLE_VALUE)
39 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
40 WHERE VARIABLE_NAME='innodb_purge_threads';
41 --enable_warnings
42 --echo 1 Expected
43
44 SELECT @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads;
45 --echo 1 Expected
46
47 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
48 SELECT COUNT(@@local.innodb_purge_threads);
49 --echo Expected error 'Variable is a GLOBAL variable'
50
51 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
52 SELECT COUNT(@@SESSION.innodb_purge_threads);
53 --echo Expected error 'Variable is a GLOBAL variable'
54
55 # Check the default value
56 --disable_warnings
57 SELECT VARIABLE_NAME, VARIABLE_VALUE
58 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
59 WHERE VARIABLE_NAME = 'innodb_purge_threads';
60 --enable_warnings
61
62
63 SET GLOBAL innodb_purge_threads = @save_threads;