Debian Codegraph @

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

raw
1 #
2 # 2011-08-01 Added
3 #
4
5
6 SET @start_global_value = @@global.innodb_api_trx_level;
7 SELECT @start_global_value;
8
9 #
10 # exists as global only
11 #
12 --echo Valid values are zero or above
13 SELECT @@global.innodb_api_trx_level >=0;
14 SELECT @@global.innodb_api_trx_level <=3;
15 SELECT @@global.innodb_api_trx_level;
16
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 SELECT @@session.innodb_api_trx_level;
19 SHOW global variables LIKE 'innodb_api_trx_level';
20 SHOW session variables LIKE 'innodb_api_trx_level';
21 --disable_warnings
22 SELECT * FROM performance_schema.global_variables
23 WHERE variable_name='innodb_api_trx_level';
24 SELECT * FROM performance_schema.session_variables
25 WHERE variable_name='innodb_api_trx_level';
26 --enable_warnings
27
28 #
29 # show that it's writable
30 #
31 SET global innodb_api_trx_level=100;
32 SELECT @@global.innodb_api_trx_level;
33 --disable_warnings
34 SELECT * FROM performance_schema.global_variables
35 WHERE variable_name='innodb_api_trx_level';
36 SELECT * FROM performance_schema.session_variables
37 WHERE variable_name='innodb_api_trx_level';
38 --enable_warnings
39 --error ER_GLOBAL_VARIABLE
40 SET session innodb_api_trx_level=1;
41
42 #
43 # incorrect types
44 #
45 --error ER_WRONG_TYPE_FOR_VAR
46 SET global innodb_api_trx_level=1.1;
47 --error ER_WRONG_TYPE_FOR_VAR
48 SET global innodb_api_trx_level=1e1;
49 --error ER_WRONG_TYPE_FOR_VAR
50 SET global innodb_api_trx_level="foo";
51 SET global innodb_api_trx_level=-7;
52 SELECT @@global.innodb_api_trx_level;
53 --disable_warnings
54 SELECT * FROM performance_schema.global_variables
55 WHERE variable_name='innodb_api_trx_level';
56 --enable_warnings
57
58 #
59 # cleanup
60 #
61
62 SET @@global.innodb_api_trx_level = @start_global_value;
63 SELECT @@global.innodb_api_trx_level;