Debian Codegraph @

mysql-test/suite/innodb/t/ibuf_with_validate_tablespace.test

raw
1 --echo #
2 --echo # Bug 35208990 - MySQL 8.0.32U1/Cloud reports wrong results (select)
3 --echo #
4
5 # innodb_change_buffering_debug option is debug only
6 --source include/have_debug.inc
7 call mtr.add_suppression("Failed to find tablespace for table .* in the cache. Attempting to load the tablespace with space id");
8 # Suppress the known warnings in the read-only-mode
9 --source include/add_mtr_suppression_for_innodb_readonly.inc
10 CREATE TABLE t1(
11 a INT AUTO_INCREMENT PRIMARY KEY,
12 b CHAR(1),
13 c INT,
14 INDEX(b))
15 ENGINE=InnoDB STATS_PERSISTENT=0;
16 # The flag innodb_change_buffering_debug is only available in debug builds.
17 # It instructs InnoDB to try to evict pages from the buffer pool when
18 # change buffering is possible, so that the change buffer will be used
19 # whenever possible.
20 SET GLOBAL innodb_change_buffering_debug = 1;
21 # Create enough rows for the table, so that the change buffer will be
22 # used for modifying the secondary index page. There must be multiple
23 # index pages, because changes to the root page are never buffered.
24 INSERT INTO t1 VALUES(0,'x',1);
25 INSERT INTO t1 SELECT 0,b,c FROM t1;
26 INSERT INTO t1 SELECT 0,b,c FROM t1;
27 INSERT INTO t1 SELECT 0,b,c FROM t1;
28 INSERT INTO t1 SELECT 0,b,c FROM t1;
29 INSERT INTO t1 SELECT 0,b,c FROM t1;
30 INSERT INTO t1 SELECT 0,b,c FROM t1;
31 INSERT INTO t1 SELECT 0,b,c FROM t1;
32 INSERT INTO t1 SELECT 0,b,c FROM t1;
33 INSERT INTO t1 SELECT 0,b,c FROM t1;
34 INSERT INTO t1 SELECT 0,b,c FROM t1;
35 INSERT INTO t1 SELECT 0,b,c FROM t1;
36 INSERT INTO t1 SELECT 0,b,c FROM t1;
37 INSERT INTO t1 SELECT 0,b,c FROM t1;
38 let $restart_parameters = restart: --innodb-validate-tablespace-paths=OFF;
39 --source include/restart_mysqld.inc
40 --sleep 10
41 check table t1;
42 let $restart_parameters = restart;
43 --source include/restart_mysqld.inc
44 # Cleanup
45 DROP TABLE t1;
46