Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-27 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_spin_wait_delay;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid values are zero or above
15 select @@global.innodb_spin_wait_delay >=0;
16 select @@global.innodb_spin_wait_delay;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 select @@session.innodb_spin_wait_delay;
19 show global variables like 'innodb_spin_wait_delay';
20 show session variables like 'innodb_spin_wait_delay';
21 --disable_warnings
22 select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay';
23 select * from information_schema.session_variables where variable_name='innodb_spin_wait_delay';
24 --enable_warnings
25
26 #
27 # show that it's writable
28 #
29 set global innodb_spin_wait_delay=10;
30 select @@global.innodb_spin_wait_delay;
31 --disable_warnings
32 select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay';
33 select * from information_schema.session_variables where variable_name='innodb_spin_wait_delay';
34 --enable_warnings
35 --error ER_GLOBAL_VARIABLE
36 set session innodb_spin_wait_delay=1;
37
38 #
39 # check the default value
40 #
41 set global innodb_spin_wait_delay=DEFAULT;
42 select @@global.innodb_spin_wait_delay;
43
44 #
45 # valid values
46 #
47 set global innodb_spin_wait_delay=0;
48 select @@global.innodb_spin_wait_delay;
49 set global innodb_spin_wait_delay=5000;
50 select @@global.innodb_spin_wait_delay;
51 #
52 # invalid values
53 #
54 set global innodb_spin_wait_delay=65535;
55 select @@global.innodb_spin_wait_delay;
56 set global innodb_spin_wait_delay=4294967295;
57 select @@global.innodb_spin_wait_delay;
58 set @@global.innodb_spin_wait_delay = 4294967296;
59 select @@global.innodb_spin_wait_delay;
60 set @@global.innodb_spin_wait_delay = 12345678901;
61 select @@global.innodb_spin_wait_delay;
62 set @@global.innodb_spin_wait_delay = 18446744073709551615;
63 select @@global.innodb_spin_wait_delay;
64
65 #
66 # incorrect types
67 #
68 --error ER_WRONG_TYPE_FOR_VAR
69 set global innodb_spin_wait_delay=1.1;
70 --error ER_WRONG_TYPE_FOR_VAR
71 set global innodb_spin_wait_delay=1e1;
72 --error ER_WRONG_TYPE_FOR_VAR
73 set global innodb_spin_wait_delay="foo";
74 --error ER_WRONG_TYPE_FOR_VAR
75 set global innodb_spin_wait_delay=' ';
76 select @@global.innodb_spin_wait_delay;
77 --error ER_WRONG_TYPE_FOR_VAR
78 set global innodb_spin_wait_delay=" ";
79 select @@global.innodb_spin_wait_delay;
80 set global innodb_spin_wait_delay=-7;
81 select @@global.innodb_spin_wait_delay;
82 set global innodb_spin_wait_delay=-1024;
83 select @@global.innodb_spin_wait_delay;
84 --disable_warnings
85 select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay';
86 --enable_warnings
87
88 #
89 # cleanup
90 #
91 SET @@global.innodb_spin_wait_delay = @start_global_value;
92 SELECT @@global.innodb_spin_wait_delay;