Quelle  lock_secondary.result   Sprache: Lisp

#
# MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history
#
CREATE TABLE t(a INT PRIMARY KEY, b TEXT, UNIQUE(b(1)))
ENGINE=InnoDB STATS_PERSISTENT=0;
connect  purge_control,localhost,root,,;
START TRANSACTION WITH CONSISTENT SNAPSHOT;
connection default;
SET GLOBAL innodb_max_purge_lag_wait=1;
INSERT INTO t VALUES
(1,REPEAT('x',@@innodb_page_size/2)),(2,REPEAT('z',@@innodb_page_size/2));
DELETE FROM t;
SELECT variable_value INTO @reads
FROM information_schema.global_status
WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
INSERT INTO t VALUES(0,'y'),(1,'x'),(2,'z');
SELECT variable_value-@reads INTO @diff
FROM information_schema.global_status
WHERE variable_name = 'INNODB_BUFFER_POOL_READ_REQUESTS';
SELECT if(@diff between 22 and 26,'ok',@diff);
if(@diff between 22 and 26,'ok',@diff)
ok
disconnect purge_control;
DROP TABLE t;