Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_limit_optimistic_insert_debug;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.innodb_limit_optimistic_insert_debug;
6 @@global.innodb_limit_optimistic_insert_debug
7 0
8 select @@session.innodb_limit_optimistic_insert_debug;
9 ERROR HY000: Variable 'innodb_limit_optimistic_insert_debug' is a GLOBAL variable
10 show global variables like 'innodb_limit_optimistic_insert_debug';
11 Variable_name Value
12 innodb_limit_optimistic_insert_debug 0
13 show session variables like 'innodb_limit_optimistic_insert_debug';
14 Variable_name Value
15 innodb_limit_optimistic_insert_debug 0
16 select * from performance_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug';
17 VARIABLE_NAME VARIABLE_VALUE
18 innodb_limit_optimistic_insert_debug 0
19 select * from performance_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug';
20 VARIABLE_NAME VARIABLE_VALUE
21 innodb_limit_optimistic_insert_debug 0
22 set global innodb_limit_optimistic_insert_debug=1;
23 select @@global.innodb_limit_optimistic_insert_debug;
24 @@global.innodb_limit_optimistic_insert_debug
25 1
26 select * from performance_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug';
27 VARIABLE_NAME VARIABLE_VALUE
28 innodb_limit_optimistic_insert_debug 1
29 select * from performance_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug';
30 VARIABLE_NAME VARIABLE_VALUE
31 innodb_limit_optimistic_insert_debug 1
32 set @@global.innodb_limit_optimistic_insert_debug=0;
33 select @@global.innodb_limit_optimistic_insert_debug;
34 @@global.innodb_limit_optimistic_insert_debug
35 0
36 select * from performance_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug';
37 VARIABLE_NAME VARIABLE_VALUE
38 innodb_limit_optimistic_insert_debug 0
39 select * from performance_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug';
40 VARIABLE_NAME VARIABLE_VALUE
41 innodb_limit_optimistic_insert_debug 0
42 set session innodb_limit_optimistic_insert_debug='some';
43 ERROR HY000: Variable 'innodb_limit_optimistic_insert_debug' is a GLOBAL variable and should be set with SET GLOBAL
44 set @@session.innodb_limit_optimistic_insert_debug='some';
45 ERROR HY000: Variable 'innodb_limit_optimistic_insert_debug' is a GLOBAL variable and should be set with SET GLOBAL
46 set global innodb_limit_optimistic_insert_debug=1.1;
47 ERROR 42000: Incorrect argument type to variable 'innodb_limit_optimistic_insert_debug'
48 set global innodb_limit_optimistic_insert_debug='foo';
49 ERROR 42000: Incorrect argument type to variable 'innodb_limit_optimistic_insert_debug'
50 set global innodb_limit_optimistic_insert_debug=-2;
51 Warnings:
52 Warning 1292 Truncated incorrect innodb_limit_optimistic_insert_debug value: '-2'
53 set global innodb_limit_optimistic_insert_debug=1e1;
54 ERROR 42000: Incorrect argument type to variable 'innodb_limit_optimistic_insert_debug'
55 SET @@global.innodb_limit_optimistic_insert_debug = @start_global_value;
56 SELECT @@global.innodb_limit_optimistic_insert_debug;
57 @@global.innodb_limit_optimistic_insert_debug
58 0