Debian Codegraph @

mysql-test/suite/innodb/r/lock_secondary.result

raw
1 #
2 # MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history
3 #
4 CREATE TABLE t(a INT PRIMARY KEY, b TEXT, UNIQUE(b(1)))
5 ENGINE=InnoDB STATS_PERSISTENT=0;
6 connect purge_control,localhost,root,,;
7 START TRANSACTION WITH CONSISTENT SNAPSHOT;
8 connection default;
9 SET GLOBAL innodb_max_purge_lag_wait=1;
10 INSERT INTO t VALUES
11 (1,REPEAT('x',@@innodb_page_size/2)),(2,REPEAT('z',@@innodb_page_size/2));
12 DELETE FROM t;
13 SELECT variable_value INTO @reads
14 FROM information_schema.global_status
15 WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
16 INSERT INTO t VALUES(0,'y'),(1,'x'),(2,'z');
17 SELECT variable_value-@reads INTO @diff
18 FROM information_schema.global_status
19 WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
20 SELECT if(@diff between 22 and 26,'ok',@diff);
21 if(@diff between 22 and 26,'ok',@diff)
22 ok
23 disconnect purge_control;
24 DROP TABLE t;