Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 SET @start_global_value = @@global.innodb_limit_optimistic_insert_debug;
4 SELECT @start_global_value;
5
6 #
7 # exists as global only
8 #
9 select @@global.innodb_limit_optimistic_insert_debug;
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.innodb_limit_optimistic_insert_debug;
12 show global variables like 'innodb_limit_optimistic_insert_debug';
13 show session variables like 'innodb_limit_optimistic_insert_debug';
14 --disable_warnings
15 select * from performance_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug';
16 select * from performance_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug';
17 --enable_warnings
18
19 #
20 # show that it's writable
21 #
22 set global innodb_limit_optimistic_insert_debug=1;
23 select @@global.innodb_limit_optimistic_insert_debug;
24 --disable_warnings
25 select * from performance_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug';
26 select * from performance_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug';
27 --enable_warnings
28 set @@global.innodb_limit_optimistic_insert_debug=0;
29 select @@global.innodb_limit_optimistic_insert_debug;
30 --disable_warnings
31 select * from performance_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug';
32 select * from performance_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug';
33 --enable_warnings
34 --error ER_GLOBAL_VARIABLE
35 set session innodb_limit_optimistic_insert_debug='some';
36 --error ER_GLOBAL_VARIABLE
37 set @@session.innodb_limit_optimistic_insert_debug='some';
38
39 #
40 # incorrect types
41 #
42 --error ER_WRONG_TYPE_FOR_VAR
43 set global innodb_limit_optimistic_insert_debug=1.1;
44 --error ER_WRONG_TYPE_FOR_VAR
45 set global innodb_limit_optimistic_insert_debug='foo';
46 set global innodb_limit_optimistic_insert_debug=-2;
47 --error ER_WRONG_TYPE_FOR_VAR
48 set global innodb_limit_optimistic_insert_debug=1e1;
49
50 #
51 # Cleanup
52 #
53
54 SET @@global.innodb_limit_optimistic_insert_debug = @start_global_value;
55 SELECT @@global.innodb_limit_optimistic_insert_debug;