Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_commit_concurrency;
2 SELECT @global_start_value;
3 @global_start_value
4 0
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_commit_concurrency = 0;
7 SET @@global.innodb_commit_concurrency = DEFAULT;
8 SELECT @@global.innodb_commit_concurrency;
9 @@global.innodb_commit_concurrency
10 0
11 '#---------------------FN_DYNVARS_046_02-------------------------#'
12 SET innodb_commit_concurrency = 1;
13 ERROR HY000: Variable 'innodb_commit_concurrency' is a GLOBAL variable and should be set with SET GLOBAL
14 SELECT @@innodb_commit_concurrency;
15 @@innodb_commit_concurrency
16 0
17 SELECT local.innodb_commit_concurrency;
18 ERROR 42S02: Unknown table 'local' in field list
19 SET global innodb_commit_concurrency = 0;
20 SELECT @@global.innodb_commit_concurrency;
21 @@global.innodb_commit_concurrency
22 0
23 '#--------------------FN_DYNVARS_046_03------------------------#'
24 SET @@global.innodb_commit_concurrency = 0;
25 SELECT @@global.innodb_commit_concurrency;
26 @@global.innodb_commit_concurrency
27 0
28 '#--------------------FN_DYNVARS_046_04-------------------------#'
29 SET @@global.innodb_commit_concurrency = 1;
30 ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1'
31 SELECT @@global.innodb_commit_concurrency;
32 @@global.innodb_commit_concurrency
33 0
34 SET @@global.innodb_commit_concurrency = -1;
35 ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '-1'
36 SELECT @@global.innodb_commit_concurrency;
37 @@global.innodb_commit_concurrency
38 0
39 SET @@global.innodb_commit_concurrency = "T";
40 ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
41 SELECT @@global.innodb_commit_concurrency;
42 @@global.innodb_commit_concurrency
43 0
44 SET @@global.innodb_commit_concurrency = "Y";
45 ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
46 SELECT @@global.innodb_commit_concurrency;
47 @@global.innodb_commit_concurrency
48 0
49 SET @@global.innodb_commit_concurrency = 1.1;
50 ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
51 SELECT @@global.innodb_commit_concurrency;
52 @@global.innodb_commit_concurrency
53 0
54 SET @@global.innodb_commit_concurrency = 1001;
55 ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1001'
56 SELECT @@global.innodb_commit_concurrency;
57 @@global.innodb_commit_concurrency
58 0
59 '#----------------------FN_DYNVARS_046_05------------------------#'
60 SELECT @@global.innodb_commit_concurrency =
61 VARIABLE_VALUE FROM performance_schema.global_variables
62 WHERE VARIABLE_NAME='innodb_commit_concurrency';
63 @@global.innodb_commit_concurrency =
64 VARIABLE_VALUE
65 1
66 SELECT @@global.innodb_commit_concurrency;
67 @@global.innodb_commit_concurrency
68 0
69 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
70 WHERE VARIABLE_NAME='innodb_commit_concurrency';
71 VARIABLE_VALUE
72 0
73 '#---------------------FN_DYNVARS_046_06-------------------------#'
74 SET @@global.innodb_commit_concurrency = OFF;
75 ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
76 SELECT @@global.innodb_commit_concurrency;
77 @@global.innodb_commit_concurrency
78 0
79 SET @@global.innodb_commit_concurrency = ON;
80 ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
81 SELECT @@global.innodb_commit_concurrency;
82 @@global.innodb_commit_concurrency
83 0
84 SET @@global.innodb_commit_concurrency = @global_start_value;
85 SELECT @@global.innodb_commit_concurrency;
86 @@global.innodb_commit_concurrency
87 0