Debian Codegraph @

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

raw
1 --source include/no_valgrind_without_big.inc
2
3 CREATE TABLE `t`
4 (`id` INT NOT NULL AUTO_INCREMENT,
5 `b` LONGBLOB,
6 PRIMARY KEY(`id`)) ENGINE=InnoDB;
7
8 DELIMITER $;
9 CREATE PROCEDURE p(p_num INT)
10 BEGIN
11 DECLARE v_i INT DEFAULT 0;
12 REPEAT
13 UPDATE t SET b:=REPEAT('a',FLOOR(1024*1024*4));
14 UPDATE t SET b:='';
15 SET v_i:=v_i+1;
16 UNTIL v_i>p_num END REPEAT;
17 END $
18 DELIMITER ;$
19
20 SET @b:=repeat('b',4*1024*1024);
21 INSERT INTO t(id,b) VALUES(1,@b);
22
23 START TRANSACTION;
24 CALL p(20);
25 COMMIT;
26
27 FLUSH TABLES `t` FOR EXPORT;
28 UNLOCK TABLES;
29
30 SET @fs1 = (SELECT file_size FROM information_schema.innodb_tablespaces
31 WHERE name = 'test/t');
32
33 START TRANSACTION;
34 CALL p(20);
35 COMMIT;
36
37 FLUSH TABLES `t` FOR EXPORT;
38 UNLOCK TABLES;
39
40 SET @fs2 = (SELECT file_size FROM information_schema.innodb_tablespaces
41 WHERE name = 'test/t');
42
43 SET @growing = (SELECT (@fs2 - @fs1));
44
45 SELECT @growing;
46
47 if (`SELECT @growing > 0`) {
48 --echo Error: The ibd file 'test/t.ibd' is growing.
49
50 }
51
52 START TRANSACTION;
53 CALL p(20);
54 ROLLBACK;
55
56 FLUSH TABLES `t` FOR EXPORT;
57 UNLOCK TABLES;
58
59 SET @fs3 = (SELECT file_size FROM information_schema.innodb_tablespaces
60 WHERE name = 'test/t');
61
62 SET @growing = (SELECT (@fs3 - @fs2));
63
64 SELECT @growing;
65
66 if (`SELECT @growing > 0`) {
67 --echo Error: The ibd file 'test/t.ibd' is growing.
68
69 }
70
71 DROP PROCEDURE p;
72 DROP TABLE t;