Debian Codegraph @

mysql-test/suite/innodb/t/update-ext.test

raw
1 --echo #
2 --echo # Bug #28560650 SERVER CRASH ON EXECUTING UPDATE QUERY USING
3 --echo # REPEAT FUNC(SIGSEGV VIOLATION)
4 --echo #
5
6 CREATE TABLE t1
7 ( a INT PRIMARY KEY,
8 d INT NOT NULL,
9 b VARCHAR(5000) NOT NULL,
10 c VARCHAR(5000),
11 vcol1 INT AS (a + 3) VIRTUAL,
12 vcol2 INT AS (a + 5) VIRTUAL,
13 vcol3 INT AS (a + 7) VIRTUAL,
14 vcol4 INT AS (a + 7) VIRTUAL,
15 vadcol INT AS (a + LENGTH(d)) STORED,
16 vbcol CHAR(2) AS (SUBSTR(b,2,2)) VIRTUAL,
17 vbidxcol CHAR(3) AS (SUBSTR(b,1,3)) VIRTUAL,
18 INDEX(vcol1),
19 INDEX(vcol2),
20 INDEX(vcol3),
21 INDEX(vcol4),
22 INDEX(vbidxcol));
23
24 INSERT INTO t1 (a, d, b, c)
25 VALUES (1, 1, REPEAT('x', 4000), REPEAT('y', 4000));
26 INSERT INTO t1 (a, d, b, c)
27 VALUES (2, 1, REPEAT('i', 100), REPEAT('z', 5000));
28
29 SELECT a, d, LEFT(b, 10), LEFT(c, 10), vcol1, vcol2, vcol3, vcol4,
30 vadcol, vbcol, vbidxcol FROM t1;
31
32 UPDATE t1
33 SET b = REPEAT('a', 4000),
34 vbidxcol = DEFAULT
35 WHERE a = 2;
36
37 SELECT a, d, LEFT(b, 10), LEFT(c, 10), vcol1, vcol2, vcol3, vcol4,
38 vadcol, vbcol, vbidxcol FROM t1;
39
40 DROP TABLE t1;