Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_api_trx_level;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 Valid values are zero or above
6 SELECT @@global.innodb_api_trx_level >=0;
7 @@global.innodb_api_trx_level >=0
8 1
9 SELECT @@global.innodb_api_trx_level <=3;
10 @@global.innodb_api_trx_level <=3
11 1
12 SELECT @@global.innodb_api_trx_level;
13 @@global.innodb_api_trx_level
14 0
15 SELECT @@session.innodb_api_trx_level;
16 ERROR HY000: Variable 'innodb_api_trx_level' is a GLOBAL variable
17 SHOW global variables LIKE 'innodb_api_trx_level';
18 Variable_name Value
19 innodb_api_trx_level 0
20 SHOW session variables LIKE 'innodb_api_trx_level';
21 Variable_name Value
22 innodb_api_trx_level 0
23 SELECT * FROM performance_schema.global_variables
24 WHERE variable_name='innodb_api_trx_level';
25 VARIABLE_NAME VARIABLE_VALUE
26 innodb_api_trx_level 0
27 SELECT * FROM performance_schema.session_variables
28 WHERE variable_name='innodb_api_trx_level';
29 VARIABLE_NAME VARIABLE_VALUE
30 innodb_api_trx_level 0
31 SET global innodb_api_trx_level=100;
32 Warnings:
33 Warning 1292 Truncated incorrect innodb_api_trx_level value: '100'
34 SELECT @@global.innodb_api_trx_level;
35 @@global.innodb_api_trx_level
36 3
37 SELECT * FROM performance_schema.global_variables
38 WHERE variable_name='innodb_api_trx_level';
39 VARIABLE_NAME VARIABLE_VALUE
40 innodb_api_trx_level 3
41 SELECT * FROM performance_schema.session_variables
42 WHERE variable_name='innodb_api_trx_level';
43 VARIABLE_NAME VARIABLE_VALUE
44 innodb_api_trx_level 3
45 SET session innodb_api_trx_level=1;
46 ERROR HY000: Variable 'innodb_api_trx_level' is a GLOBAL variable and should be set with SET GLOBAL
47 SET global innodb_api_trx_level=1.1;
48 ERROR 42000: Incorrect argument type to variable 'innodb_api_trx_level'
49 SET global innodb_api_trx_level=1e1;
50 ERROR 42000: Incorrect argument type to variable 'innodb_api_trx_level'
51 SET global innodb_api_trx_level="foo";
52 ERROR 42000: Incorrect argument type to variable 'innodb_api_trx_level'
53 SET global innodb_api_trx_level=-7;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_api_trx_level value: '-7'
56 SELECT @@global.innodb_api_trx_level;
57 @@global.innodb_api_trx_level
58 0
59 SELECT * FROM performance_schema.global_variables
60 WHERE variable_name='innodb_api_trx_level';
61 VARIABLE_NAME VARIABLE_VALUE
62 innodb_api_trx_level 0
63 SET @@global.innodb_api_trx_level = @start_global_value;
64 SELECT @@global.innodb_api_trx_level;
65 @@global.innodb_api_trx_level
66 0