Debian Codegraph @

mysql-test/suite/innodb/r/lob_ibd_size_replace.result

raw
1 #
2 # BUG 31222046 - .IDB GROWS INDEFENITELY (BUG #96466 WITH REPLACE)
3 #
4 CREATE TABLE `my_sample_table`
5 (`id` INT NOT NULL AUTO_INCREMENT,
6 `name` VARCHAR(128) NOT NULL,
7 `some_data` MEDIUMBLOB,
8 `update_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
9 PRIMARY KEY (`id`),
10 UNIQUE KEY `name` (`name`));
11 CREATE PROCEDURE p(p_num INT)
12 BEGIN
13 DECLARE v_i INT DEFAULT 0;
14 REPEAT
15 REPLACE INTO my_sample_table (id, name, some_data) VALUES (1, 'data1', REPEAT('x',7609));
16 REPLACE INTO my_sample_table (id, name, some_data) VALUES (1, 'data1', REPEAT('t', 4184950));
17 SET v_i:=v_i+1;
18 UNTIL v_i>p_num END REPEAT;
19 END $
20 REPLACE INTO my_sample_table (id, name, some_data) VALUES (1, 'data1', REPEAT('t', 4184950));
21 START TRANSACTION;
22 CALL p(30);
23 COMMIT;
24 FLUSH TABLES `my_sample_table` FOR EXPORT;
25 UNLOCK TABLES;
26 SET @fs1 = (SELECT file_size FROM information_schema.innodb_tablespaces
27 WHERE name = 'test/my_sample_table');
28 START TRANSACTION;
29 CALL p(30);
30 COMMIT;
31 FLUSH TABLES `my_sample_table` FOR EXPORT;
32 UNLOCK TABLES;
33 SET @fs2 = (SELECT file_size FROM information_schema.innodb_tablespaces
34 WHERE name = 'test/my_sample_table');
35 SET @growing = (SELECT (@fs2 - @fs1));
36 SELECT @growing;
37 @growing
38 0
39 START TRANSACTION;
40 CALL p(30);
41 ROLLBACK;
42 FLUSH TABLES `my_sample_table` FOR EXPORT;
43 UNLOCK TABLES;
44 SET @fs3 = (SELECT file_size FROM information_schema.innodb_tablespaces
45 WHERE name = 'test/my_sample_table');
46 SET @growing = (SELECT (@fs3 - @fs2));
47 SELECT @growing;
48 @growing
49 0
50 DROP PROCEDURE p;
51 DROP TABLE my_sample_table;