Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history
5 --echo #
6 CREATE TABLE t(a INT PRIMARY KEY, b TEXT, UNIQUE(b(1)))
7 ENGINE=InnoDB STATS_PERSISTENT=0;
8
9 connect (purge_control,localhost,root,,);
10 START TRANSACTION WITH CONSISTENT SNAPSHOT;
11 connection default;
12 SET GLOBAL innodb_max_purge_lag_wait=1;
13
14 INSERT INTO t VALUES
15 (1,REPEAT('x',@@innodb_page_size/2)),(2,REPEAT('z',@@innodb_page_size/2));
16 DELETE FROM t;
17
18 SELECT variable_value INTO @reads
19 FROM information_schema.global_status
20 WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
21
22 INSERT INTO t VALUES(0,'y'),(1,'x'),(2,'z');
23
24 SELECT variable_value-@reads INTO @diff
25 FROM information_schema.global_status
26 WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
27
28 # Typically, this reports 24 pages accessed.
29 # If the fix is absent, we would access at least 26 pages.
30 SELECT if(@diff between 22 and 26,'ok',@diff);
31 disconnect purge_control;
32
33 DROP TABLE t;