Debian Codegraph @

mysql-test/suite/innodb/t/innodb_stats_persistent_debug.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3
4 --echo #
5 --echo # MDEV-13534 InnoDB STATS_PERSISTENT fails to ignore
6 --echo # garbage delete-mark flag on node pointer pages
7 --echo #
8
9 CREATE TABLE t(a INT UNSIGNED PRIMARY KEY)
10 ENGINE=InnoDB STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1;
11
12 BEGIN;
13 # Create an index tree of height 3.
14 # This is adapted from innodb.innodb_bug14676111.
15
16 SET @save_debug = @@GLOBAL.innodb_limit_optimistic_insert_debug;
17 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
18
19 INSERT t VALUES(1),(5);
20 DELETE FROM t;
21 INSERT t VALUES(4);
22 DELETE FROM t;
23 INSERT t VALUES(3);
24 DELETE FROM t;
25 SET GLOBAL innodb_limit_optimistic_insert_debug = @save_debug;
26
27 connect(con1, localhost, root,,);
28 ANALYZE TABLE t;
29 disconnect con1;
30
31 connection default;
32 DROP TABLE t;