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