Debian Codegraph @

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

raw
1 --echo #
2 --echo # Basic test for innodb_fil_make_page_dirty_debug.
3 --echo #
4
5
6 # The config variable is a debug variable
7 -- source include/have_debug.inc
8
9 SELECT @@global.innodb_fil_make_page_dirty_debug;
10
11 set global innodb_fil_make_page_dirty_debug = 1000;
12
13 SELECT @@global.innodb_fil_make_page_dirty_debug;
14
15 set global innodb_fil_make_page_dirty_debug = 1000;
16
17 --error ER_WRONG_TYPE_FOR_VAR
18 set global innodb_fil_make_page_dirty_debug = dummy;
19
20 --error ER_GLOBAL_VARIABLE
21 set innodb_fil_make_page_dirty_debug = ON;
22
23 --echo # An example usage.
24 create table t1 (f1 int primary key) engine = innodb;
25 select space from information_schema.innodb_tables
26 where name = 'test/t1' into @space_id;
27 # Ensure that the page is out of range otherwise it will force a crash
28 # in the double write code.
29 set global innodb_saved_page_number_debug = 1000;
30 set global innodb_fil_make_page_dirty_debug = @space_id;
31 drop table t1;
32
33 set global innodb_saved_page_number_debug = 0;
34
35 --echo # Must always be 0.
36 SELECT @@global.innodb_fil_make_page_dirty_debug;
37