Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.deadlock_search_depth_long;
2 select @@global.deadlock_search_depth_long;
3 @@global.deadlock_search_depth_long
4 15
5 select @@session.deadlock_search_depth_long;
6 @@session.deadlock_search_depth_long
7 15
8 show global variables like 'deadlock_search_depth_long';
9 Variable_name Value
10 deadlock_search_depth_long 15
11 show session variables like 'deadlock_search_depth_long';
12 Variable_name Value
13 deadlock_search_depth_long 15
14 select * from information_schema.global_variables where variable_name='deadlock_search_depth_long';
15 VARIABLE_NAME VARIABLE_VALUE
16 DEADLOCK_SEARCH_DEPTH_LONG 15
17 select * from information_schema.session_variables where variable_name='deadlock_search_depth_long';
18 VARIABLE_NAME VARIABLE_VALUE
19 DEADLOCK_SEARCH_DEPTH_LONG 15
20 set global deadlock_search_depth_long=10;
21 select @@global.deadlock_search_depth_long;
22 @@global.deadlock_search_depth_long
23 10
24 set session deadlock_search_depth_long=10;
25 select @@session.deadlock_search_depth_long;
26 @@session.deadlock_search_depth_long
27 10
28 set global deadlock_search_depth_long=1.1;
29 ERROR 42000: Incorrect argument type to variable 'deadlock_search_depth_long'
30 set session deadlock_search_depth_long=1e1;
31 ERROR 42000: Incorrect argument type to variable 'deadlock_search_depth_long'
32 set global deadlock_search_depth_long="foo";
33 ERROR 42000: Incorrect argument type to variable 'deadlock_search_depth_long'
34 set global deadlock_search_depth_long=0;
35 select @@global.deadlock_search_depth_long;
36 @@global.deadlock_search_depth_long
37 0
38 set session deadlock_search_depth_long=cast(-1 as unsigned int);
39 Warnings:
40 Note 1105 Cast to unsigned converted negative integer to it's positive complement
41 Warning 1292 Truncated incorrect deadlock_search_depth_long value: '18446744073709551615'
42 select @@session.deadlock_search_depth_long;
43 @@session.deadlock_search_depth_long
44 33
45 SET @@global.deadlock_search_depth_long = @start_global_value;