Debian Codegraph @

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

raw
1 # Variable Name: innodb_max_purge_lag_delay
2 # Scope: Global #
3 # Access Type: Static #
4 # Data Type: numeric #
5
6 --source include/have_innodb.inc
7
8 SELECT @@GLOBAL.innodb_max_purge_lag_delay;
9 --echo 0 Expected
10
11 SET @@GLOBAL.innodb_max_purge_lag_delay=1;
12
13 SELECT COUNT(@@GLOBAL.innodb_max_purge_lag_delay);
14 --echo 1 Expected
15
16 --disable_warnings
17 SELECT VARIABLE_VALUE
18 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
19 WHERE VARIABLE_NAME='innodb_max_purge_lag_delay';
20 --enable_warnings
21 --echo 1 Expected
22
23 SELECT @@innodb_max_purge_lag_delay = @@GLOBAL.innodb_max_purge_lag_delay;
24 --echo 1 Expected
25
26 SELECT COUNT(@@innodb_max_purge_lag_delay);
27 --echo 1 Expected
28
29 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 SELECT COUNT(@@local.innodb_max_purge_lag_delay);
31 --echo Expected error 'Variable is a GLOBAL variable'
32
33 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
34 SELECT COUNT(@@SESSION.innodb_max_purge_lag_delay);
35 --echo Expected error 'Variable is a GLOBAL variable'
36
37 --Error ER_BAD_FIELD_ERROR
38 SELECT innodb_max_purge_lag_delay = @@SESSION.innodb_max_purge_lag_delay;
39
40 set global innodb_max_purge_lag_delay = -1;
41 set global innodb_max_purge_lag_delay = 1000000;
42 set global innodb_max_purge_lag_delay = 10000000;
43 set global innodb_max_purge_lag_delay = 100000000;
44 set global innodb_max_purge_lag_delay = 100000001;
45 set global innodb_max_purge_lag_delay = 0;