Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_purge_threads);
2 COUNT(@@GLOBAL.innodb_purge_threads)
3 1
4 1 Expected
5 SELECT COUNT(@@innodb_purge_threads);
6 COUNT(@@innodb_purge_threads)
7 1
8 1 Expected
9 SET @save_threads = @@GLOBAL.innodb_purge_threads;
10 SET @@GLOBAL.innodb_purge_threads=-1;
11 Warnings:
12 Warning 1292 Truncated incorrect innodb_purge_threads value: '-1'
13 SELECT @@GLOBAL.innodb_purge_threads;
14 @@GLOBAL.innodb_purge_threads
15 1
16 SET @@GLOBAL.innodb_purge_threads=0;
17 Warnings:
18 Warning 1292 Truncated incorrect innodb_purge_threads value: '0'
19 SELECT @@GLOBAL.innodb_purge_threads;
20 @@GLOBAL.innodb_purge_threads
21 1
22 SET @@GLOBAL.innodb_purge_threads=33;
23 Warnings:
24 Warning 1292 Truncated incorrect innodb_purge_threads value: '33'
25 SELECT @@GLOBAL.innodb_purge_threads;
26 @@GLOBAL.innodb_purge_threads
27 32
28 SET @@GLOBAL.innodb_purge_threads=1;
29 SET @@GLOBAL.innodb_purge_threads=32;
30 SELECT innodb_purge_threads = @@SESSION.innodb_purge_threads;
31 ERROR 42S22: Unknown column 'innodb_purge_threads' in 'SELECT'
32 Expected error 'Read-only variable'
33 SELECT @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE
34 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
35 WHERE VARIABLE_NAME='innodb_purge_threads';
36 @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE
37 1
38 1 Expected
39 SELECT COUNT(VARIABLE_VALUE)
40 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
41 WHERE VARIABLE_NAME='innodb_purge_threads';
42 COUNT(VARIABLE_VALUE)
43 1
44 1 Expected
45 SELECT @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads;
46 @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads
47 1
48 1 Expected
49 SELECT COUNT(@@local.innodb_purge_threads);
50 ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable
51 Expected error 'Variable is a GLOBAL variable'
52 SELECT COUNT(@@SESSION.innodb_purge_threads);
53 ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable
54 Expected error 'Variable is a GLOBAL variable'
55 SELECT VARIABLE_NAME, VARIABLE_VALUE
56 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
57 WHERE VARIABLE_NAME = 'innodb_purge_threads';
58 VARIABLE_NAME VARIABLE_VALUE
59 INNODB_PURGE_THREADS 32
60 SET GLOBAL innodb_purge_threads = @save_threads;