Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_api_bk_commit_interval;
2 SELECT @start_global_value;
3 @start_global_value
4 5
5 Valid values are positive number
6 SELECT @@global.innodb_api_bk_commit_interval > 0;
7 @@global.innodb_api_bk_commit_interval > 0
8 1
9 SELECT @@global.innodb_api_bk_commit_interval <= 1024*1024*1024;
10 @@global.innodb_api_bk_commit_interval <= 1024*1024*1024
11 1
12 SELECT @@global.innodb_api_bk_commit_interval;
13 @@global.innodb_api_bk_commit_interval
14 5
15 SELECT @@session.innodb_api_bk_commit_interval;
16 ERROR HY000: Variable 'innodb_api_bk_commit_interval' is a GLOBAL variable
17 SHOW global variables LIKE 'innodb_api_bk_commit_interval';
18 Variable_name Value
19 innodb_api_bk_commit_interval 5
20 SHOW session variables LIKE 'innodb_api_bk_commit_interval';
21 Variable_name Value
22 innodb_api_bk_commit_interval 5
23 SELECT * FROM performance_schema.global_variables
24 WHERE variable_name='innodb_api_bk_commit_interval';
25 VARIABLE_NAME VARIABLE_VALUE
26 innodb_api_bk_commit_interval 5
27 SELECT * FROM performance_schema.session_variables
28 WHERE variable_name='innodb_api_bk_commit_interval';
29 VARIABLE_NAME VARIABLE_VALUE
30 innodb_api_bk_commit_interval 5
31 SET global innodb_api_bk_commit_interval=100;
32 SELECT @@global.innodb_api_bk_commit_interval;
33 @@global.innodb_api_bk_commit_interval
34 100
35 SELECT * FROM performance_schema.global_variables
36 WHERE variable_name='innodb_api_bk_commit_interval';
37 VARIABLE_NAME VARIABLE_VALUE
38 innodb_api_bk_commit_interval 100
39 SELECT * FROM performance_schema.session_variables
40 WHERE variable_name='innodb_api_bk_commit_interval';
41 VARIABLE_NAME VARIABLE_VALUE
42 innodb_api_bk_commit_interval 100
43 SET session innodb_api_bk_commit_interval=1;
44 ERROR HY000: Variable 'innodb_api_bk_commit_interval' is a GLOBAL variable and should be set with SET GLOBAL
45 SET global innodb_api_bk_commit_interval=1;
46 SELECT @@global.innodb_api_bk_commit_interval;
47 @@global.innodb_api_bk_commit_interval
48 1
49 SET global innodb_api_bk_commit_interval=100000;
50 SELECT @@global.innodb_api_bk_commit_interval;
51 @@global.innodb_api_bk_commit_interval
52 100000
53 SET global innodb_api_bk_commit_interval=1073741824;
54 SELECT @@global.innodb_api_bk_commit_interval;
55 @@global.innodb_api_bk_commit_interval
56 1073741824
57 SET global innodb_api_bk_commit_interval=0;
58 Warnings:
59 Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '0'
60 SELECT @@global.innodb_api_bk_commit_interval;
61 @@global.innodb_api_bk_commit_interval
62 1
63 SET global innodb_api_bk_commit_interval=-1024;
64 Warnings:
65 Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '-1024'
66 SELECT @@global.innodb_api_bk_commit_interval;
67 @@global.innodb_api_bk_commit_interval
68 1
69 SET global innodb_api_bk_commit_interval=1073741825;
70 Warnings:
71 Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '1073741825'
72 SELECT @@global.innodb_api_bk_commit_interval;
73 @@global.innodb_api_bk_commit_interval
74 1073741824
75 SET global innodb_api_bk_commit_interval=4294967295;
76 Warnings:
77 Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '4294967295'
78 SELECT @@global.innodb_api_bk_commit_interval;
79 @@global.innodb_api_bk_commit_interval
80 1073741824
81 SET global innodb_api_bk_commit_interval=1.1;
82 ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval'
83 SET global innodb_api_bk_commit_interval=1e1;
84 ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval'
85 SET global innodb_api_bk_commit_interval="foo";
86 ERROR 42000: Incorrect argument type to variable 'innodb_api_bk_commit_interval'
87 SET global innodb_api_bk_commit_interval=-7;
88 Warnings:
89 Warning 1292 Truncated incorrect innodb_api_bk_commit_interval value: '-7'
90 SELECT @@global.innodb_api_bk_commit_interval;
91 @@global.innodb_api_bk_commit_interval
92 1
93 SELECT * FROM performance_schema.global_variables
94 WHERE variable_name='innodb_api_bk_commit_interval';
95 VARIABLE_NAME VARIABLE_VALUE
96 innodb_api_bk_commit_interval 1
97 SET @@global.innodb_api_bk_commit_interval = @start_global_value;
98 SELECT @@global.innodb_api_bk_commit_interval;
99 @@global.innodb_api_bk_commit_interval
100 5