Debian Codegraph @

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

raw
1 #
2 # 2012-08-01 Added
3 #
4
5
6 SET @start_global_value = @@global.innodb_api_bk_commit_interval;
7 SELECT @start_global_value;
8
9 #
10 # exists as global only
11 #
12 --echo Valid values are positive number
13 SELECT @@global.innodb_api_bk_commit_interval > 0;
14 SELECT @@global.innodb_api_bk_commit_interval <= 1024*1024*1024;
15 SELECT @@global.innodb_api_bk_commit_interval;
16
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 SELECT @@session.innodb_api_bk_commit_interval;
19 SHOW global variables LIKE 'innodb_api_bk_commit_interval';
20 SHOW session variables LIKE 'innodb_api_bk_commit_interval';
21 --disable_warnings
22 SELECT * FROM performance_schema.global_variables
23 WHERE variable_name='innodb_api_bk_commit_interval';
24 SELECT * FROM performance_schema.session_variables
25 WHERE variable_name='innodb_api_bk_commit_interval';
26 --enable_warnings
27
28 #
29 # show that it's writable
30 #
31 SET global innodb_api_bk_commit_interval=100;
32 SELECT @@global.innodb_api_bk_commit_interval;
33 --disable_warnings
34 SELECT * FROM performance_schema.global_variables
35 WHERE variable_name='innodb_api_bk_commit_interval';
36 SELECT * FROM performance_schema.session_variables
37 WHERE variable_name='innodb_api_bk_commit_interval';
38 --enable_warnings
39 --error ER_GLOBAL_VARIABLE
40 SET session innodb_api_bk_commit_interval=1;
41 #
42 # Valid values
43 #
44 SET global innodb_api_bk_commit_interval=1;
45 SELECT @@global.innodb_api_bk_commit_interval;
46 SET global innodb_api_bk_commit_interval=100000;
47 SELECT @@global.innodb_api_bk_commit_interval;
48 SET global innodb_api_bk_commit_interval=1073741824;
49 SELECT @@global.innodb_api_bk_commit_interval;
50
51 #
52 # Invalid values
53 #
54 SET global innodb_api_bk_commit_interval=0;
55 SELECT @@global.innodb_api_bk_commit_interval;
56 SET global innodb_api_bk_commit_interval=-1024;
57 SELECT @@global.innodb_api_bk_commit_interval;
58 SET global innodb_api_bk_commit_interval=1073741825;
59 SELECT @@global.innodb_api_bk_commit_interval;
60 SET global innodb_api_bk_commit_interval=4294967295;
61 SELECT @@global.innodb_api_bk_commit_interval;
62
63 #
64 # incorrect types
65 #
66 --error ER_WRONG_TYPE_FOR_VAR
67 SET global innodb_api_bk_commit_interval=1.1;
68 --error ER_WRONG_TYPE_FOR_VAR
69 SET global innodb_api_bk_commit_interval=1e1;
70 --error ER_WRONG_TYPE_FOR_VAR
71 SET global innodb_api_bk_commit_interval="foo";
72 SET global innodb_api_bk_commit_interval=-7;
73 SELECT @@global.innodb_api_bk_commit_interval;
74 --disable_warnings
75 SELECT * FROM performance_schema.global_variables
76 WHERE variable_name='innodb_api_bk_commit_interval';
77 --enable_warnings
78
79 #
80 # cleanup
81 #
82
83 SET @@global.innodb_api_bk_commit_interval = @start_global_value;
84 SELECT @@global.innodb_api_bk_commit_interval;