Debian Codegraph @

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

raw
1 --source include/big_test.inc
2 --source include/have_innodb_16k.inc
3 --source include/have_debug.inc
4 --source include/not_valgrind.inc
5
6 --echo #
7 --echo # BUG 31222046 - .IDB GROWS INDEFENITELY (BUG #96466 WITH REPLACE)
8 --echo #
9
10 SET GLOBAL innodb_compression_level = 0;
11
12 CREATE TABLE `my_sample_table`
13 (`id` INT NOT NULL AUTO_INCREMENT,
14 `name` VARCHAR(128) NOT NULL,
15 `some_data` MEDIUMBLOB,
16 `update_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
17 PRIMARY KEY (`id`),
18 UNIQUE KEY `name` (`name`)) ROW_FORMAT=COMPRESSED;
19
20 DELIMITER $;
21 CREATE PROCEDURE p(p_num INT)
22 BEGIN
23 DECLARE v_i INT DEFAULT 0;
24 REPEAT
25 REPLACE INTO my_sample_table (id, name, some_data) VALUES (1, 'data1', REPEAT('x',7609));
26 REPLACE INTO my_sample_table (id, name, some_data) VALUES (1, 'data1', REPEAT('t', 4184950));
27 SET v_i:=v_i+1;
28 UNTIL v_i>p_num END REPEAT;
29 END $
30 DELIMITER ;$
31
32 REPLACE INTO my_sample_table (id, name, some_data) VALUES (1, 'data1', REPEAT('t', 4184950));
33
34 START TRANSACTION;
35 CALL p(30);
36 COMMIT;
37
38 let $wait_timeout = 60;
39 --source include/wait_innodb_all_purged.inc
40
41 FLUSH TABLES `my_sample_table` FOR EXPORT;
42 UNLOCK TABLES;
43
44 SET @fs1 = (SELECT file_size FROM information_schema.innodb_tablespaces
45 WHERE name = 'test/my_sample_table');
46
47 START TRANSACTION;
48 CALL p(30);
49 COMMIT;
50
51 let $wait_timeout = 60;
52 --source include/wait_innodb_all_purged.inc
53
54 FLUSH TABLES `my_sample_table` FOR EXPORT;
55 UNLOCK TABLES;
56
57 SET @fs2 = (SELECT file_size FROM information_schema.innodb_tablespaces
58 WHERE name = 'test/my_sample_table');
59
60 SET @growing = (SELECT (@fs2 - @fs1));
61
62 SELECT @growing;
63
64 if (`SELECT @growing > 0`) {
65 --echo Error: The ibd file 'test/my_sample_table.ibd' is growing.
66
67 }
68
69 START TRANSACTION;
70 CALL p(30);
71 ROLLBACK;
72
73 FLUSH TABLES `my_sample_table` FOR EXPORT;
74 UNLOCK TABLES;
75
76 SET @fs3 = (SELECT file_size FROM information_schema.innodb_tablespaces
77 WHERE name = 'test/my_sample_table');
78
79 SET @growing = (SELECT (@fs3 - @fs2));
80
81 SELECT @growing;
82
83 if (`SELECT @growing > 0`) {
84 --echo Error: The ibd file 'test/my_sample_table.ibd' is growing.
85
86 }
87
88 DROP PROCEDURE p;
89 DROP TABLE my_sample_table;
90 SET GLOBAL innodb_compression_level = DEFAULT;