| 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; |