Debian Codegraph @

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

raw
1 --echo #
2 --echo # Basic test for innodb_saved_page_number_debug.
3 --echo #
4
5
6 # The config variable is a debug variable
7 -- source include/have_debug.inc
8
9 SELECT @@global.innodb_saved_page_number_debug;
10
11 set global innodb_saved_page_number_debug = 10;
12
13 SELECT @@global.innodb_saved_page_number_debug;
14
15 set global innodb_saved_page_number_debug = 100;
16
17 --error ER_WRONG_TYPE_FOR_VAR
18 set global innodb_saved_page_number_debug = dummy;
19
20 --error ER_GLOBAL_VARIABLE
21 set innodb_saved_page_number_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 set global innodb_saved_page_number_debug = 10000;
28 set global innodb_fil_make_page_dirty_debug = @space_id;
29 drop table t1;
30
31 set global innodb_saved_page_number_debug = 0;
32
33 SELECT @@global.innodb_saved_page_number_debug;
34