| 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; |