Debian Codegraph @

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

raw
1 # ulong session
2
3 SET @start_global_value = @@global.deadlock_timeout_short;
4
5 #
6 # exists as global only
7 #
8 select @@global.deadlock_timeout_short;
9 select @@session.deadlock_timeout_short;
10 show global variables like 'deadlock_timeout_short';
11 show session variables like 'deadlock_timeout_short';
12 select * from information_schema.global_variables where variable_name='deadlock_timeout_short';
13 select * from information_schema.session_variables where variable_name='deadlock_timeout_short';
14
15 #
16 # show that it's writable
17 #
18 set global deadlock_timeout_short=10;
19 select @@global.deadlock_timeout_short;
20 set session deadlock_timeout_short=10;
21 select @@session.deadlock_timeout_short;
22
23 #
24 # incorrect types
25 #
26 --error ER_WRONG_TYPE_FOR_VAR
27 set global deadlock_timeout_short=1.1;
28 --error ER_WRONG_TYPE_FOR_VAR
29 set session deadlock_timeout_short=1e1;
30 --error ER_WRONG_TYPE_FOR_VAR
31 set global deadlock_timeout_short="foo";
32
33 #
34 # min/max values, block size
35 #
36 set global deadlock_timeout_short=0;
37 select @@global.deadlock_timeout_short;
38 set session deadlock_timeout_short=cast(-1 as unsigned int);
39 select @@session.deadlock_timeout_short;
40
41 SET @@global.deadlock_timeout_short = @start_global_value;
42