--echo # --echo # Bug 35208990 - MySQL 8.0.32U1/Cloud reports wrong results (select) --echo # # innodb_change_buffering_debug option is debug only --source include/have_debug.inc call mtr.add_suppression("Failed to find tablespace for table .* in the cache. Attempting to load the tablespace with space id"); # Suppress the known warnings in the read-only-mode --source include/add_mtr_suppression_for_innodb_readonly.inc CREATE TABLE t1( a INT AUTO_INCREMENT PRIMARY KEY, b CHAR(1), c INT, INDEX(b)) ENGINE=InnoDB STATS_PERSISTENT=0; # The flag innodb_change_buffering_debug is only available in debug builds. # It instructs InnoDB to try to evict pages from the buffer pool when # change buffering is possible, so that the change buffer will be used # whenever possible. SET GLOBAL innodb_change_buffering_debug = 1; # Create enough rows for the table, so that the change buffer will be # used for modifying the secondary index page. There must be multiple # index pages, because changes to the root page are never buffered. INSERT INTO t1 VALUES(0,'x',1); INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; INSERT INTO t1 SELECT 0,b,c FROM t1; let $restart_parameters = restart: --innodb-validate-tablespace-paths=OFF; --source include/restart_mysqld.inc --sleep 10 check table t1; let $restart_parameters = restart; --source include/restart_mysqld.inc # Cleanup DROP TABLE t1;