Debian Codegraph @

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

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