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 --source include/have_innodb.inc
6
7 # The config variable is a debug variable
8 -- source include/have_debug.inc
9
10 SELECT @@global.innodb_saved_page_number_debug;
11
12 set global innodb_saved_page_number_debug = 10;
13
14 SELECT @@global.innodb_saved_page_number_debug;
15
16 set global innodb_saved_page_number_debug = 100;
17
18 --error ER_WRONG_TYPE_FOR_VAR
19 set global innodb_saved_page_number_debug = dummy;
20
21 --error ER_GLOBAL_VARIABLE
22 set innodb_saved_page_number_debug = ON;
23
24 --echo # An example usage.
25 create table t1 (f1 int primary key) engine = innodb;
26 --disable_cursor_protocol
27 --enable_prepare_warnings
28 select space from information_schema.innodb_sys_tables
29 where name = 'test/t1' into @space_id;
30 --disable_prepare_warnings
31 --enable_cursor_protocol
32 set global innodb_saved_page_number_debug = 0;
33 set global innodb_fil_make_page_dirty_debug = @space_id;
34 drop table t1;
35
36 set global innodb_saved_page_number_debug = 0;
37 set global innodb_fil_make_page_dirty_debug = 0;
38
39 SELECT @@global.innodb_saved_page_number_debug;
40