Debian Codegraph @

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

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