Debian Codegraph @

mysql-test/suite/innodb/r/update-ext.result

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