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
7 SELECT @@GLOBAL.innodb_max_purge_lag_delay;
8 --echo 0 Expected
9
10 SET @@GLOBAL.innodb_max_purge_lag_delay=1;
11
12 SELECT COUNT(@@GLOBAL.innodb_max_purge_lag_delay);
13 --echo 1 Expected
14
15 --disable_warnings
16 SELECT VARIABLE_VALUE
17 FROM performance_schema.global_variables
18 WHERE VARIABLE_NAME='innodb_max_purge_lag_delay';
19 --enable_warnings
20 --echo 1 Expected
21
22 SELECT @@innodb_max_purge_lag_delay = @@GLOBAL.innodb_max_purge_lag_delay;
23 --echo 1 Expected
24
25 SELECT COUNT(@@innodb_max_purge_lag_delay);
26 --echo 1 Expected
27
28 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
29 SELECT COUNT(@@local.innodb_max_purge_lag_delay);
30 --echo Expected error 'Variable is a GLOBAL variable'
31
32 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
33 SELECT COUNT(@@SESSION.innodb_max_purge_lag_delay);
34 --echo Expected error 'Variable is a GLOBAL variable'
35
36 --Error ER_BAD_FIELD_ERROR
37 SELECT innodb_max_purge_lag_delay;
38
39 set global innodb_max_purge_lag_delay = -1;
40 set global innodb_max_purge_lag_delay = 1000000;
41 set global innodb_max_purge_lag_delay = 10000000;
42 set global innodb_max_purge_lag_delay = 100000000;
43 set global innodb_max_purge_lag_delay = 100000001;
44 set global innodb_max_purge_lag_delay = 0;