Debian Codegraph @

mysql-test/suite/innodb/include/innodb_v_large_col.inc

raw
1
2 eval CREATE TABLE `t` (
3 `a` VARCHAR(10000), `b` VARCHAR(3000),
4 `c` VARCHAR(14000) GENERATED ALWAYS AS (CONCAT(a,b)) VIRTUAL,
5 `d` VARCHAR(5000) GENERATED ALWAYS AS (b) VIRTUAL,
6 `e` INT(11) GENERATED ALWAYS AS (10) VIRTUAL,
7 `h` INT(11) NOT NULL,
8 PRIMARY KEY (`h`) ) ROW_FORMAT=$row_format ENGINE=InnoDB charset latin1;
9
10 SHOW CREATE TABLE t;
11
12 INSERT INTO t VALUES (REPEAT('g', 10000), REPEAT('x', 2800), DEFAULT, DEFAULT, DEFAULT, 1);
13
14 INSERT INTO t VALUES (REPEAT('a', 9000), REPEAT('b', 2000), DEFAULT, DEFAULT, DEFAULT, 2);
15 INSERT INTO t VALUES (REPEAT('m', 8000), REPEAT('n', 3000), DEFAULT, DEFAULT, DEFAULT, 3);
16 CREATE INDEX idx ON t(c(100), d(20));
17 UPDATE t SET a = REPEAT(CAST(1 AS CHAR), 2000) WHERE h = 1;
18
19 delimiter |;
20 CREATE PROCEDURE UPDATE_t()
21 begin
22 DECLARE i INT DEFAULT 1;
23 WHILE (i <= 100) DO
24 UPDATE t SET a = REPEAT(CAST(i AS CHAR), 2000) WHERE h = 1;
25 SET i = i + 1;
26 END WHILE;
27 END|
28
29 CREATE PROCEDURE DELETE_insert_t()
30 begin
31 DECLARE i INT DEFAULT 1;
32 WHILE (i <= 100) DO
33 DELETE FROM t WHERE h = 1;
34 INSERT INTO t VALUES (REPEAT(CAST(i AS CHAR), 2000) , REPEAT('b', 2000), DEFAULT, DEFAULT, DEFAULT, 1);
35 SET i = i + 1;
36 END WHILE;
37 END|
38 delimiter ;|
39
40 CALL UPDATE_t();
41
42 CALL DELETE_insert_t();
43
44 UPDATE t SET a = NULL WHERE h=1;
45
46 START TRANSACTION;
47 CALL UPDATE_t();
48 ROLLBACK;
49
50 DROP PROCEDURE DELETE_insert_t;
51 DROP PROCEDURE UPDATE_t;
52 DROP TABLE t;